We need to have master spreadsheets that summarize value from different sets
of identical excel spreadsheets. We have a multi-tab template spreadsheet
that gets filled in with the data for each shipment and saved. The layout is
exactly the same for each shipment and only item serial numbers change. We
then generate another summary spreadsheet report periodically that
consolidates the serial items and numbers from the individual shipments.

Right now we are just pasting the serial numbers from the individual
shipment spreadsheets into the summary spreadsheet. I know I can reference
the cells in the other files, but I dont want to have to edit the file names
in every referencing cell for each new summary report. What I would like to
be able to do is have an area of the spreadsheet where I can enter the
variable spreadsheet file names once and have that name change throughout the
summary spreadsheet.

So, this week we have 2 shipments stored in excel spreadsheets detail1 and
detail2. We change some cells in excel spreadsheet summary1 and the data is
pulled from detail1 and detail2. We save summary1 and report on it.

Next week we have 3 shipments stored in excel spreadsheets detail3, detail4,
and detail5. We change some cells in excel spreadsheet summary2 and the data
is pulled from detail3, detail4, and detail5. We save summary2 and report on
it.

I understand the variable number of shipments report on will cause issue as
well, but right now I just want to get the dynamic file reference addressed.

And, yes, I know we would be better served using a database, but as usual
someone that didnt know better started us down this path and we cant change
now.