for committing data, create global fields, let these be in a layout that will pop up from your main layout, then upon commit, a script will move data from the pop up to the main layout -- you'll want your main layout fields to be non-enterable from/in browse mode.
for multiple spreadsheet, let the data all be in one table with fields for location and program, then perform a find (via a script) that will search for a given location and program
The only part that im lost on, is what do you mean by having it pop up? Do I make two seperate layouts and have one popping out from the other??