In my workbook (2003) used to track disaster costs, I have some 60 different
worksheets. On the Summary page, the cells pull data from the individual
worksheets.

On the Summary page, there are some 60 rows. Each row pulls data from a
different worksheet; from the same relative cells, just on different sheets.

On the Summary page, the first column is text that identifies which tab
(worksheet) that row's data is from.

My difficulty is having to manually change the formulas in each cell, in
every row, so that it pulls the data from the appropriate worksheet. There's
gotta be a way for the formulas within each row, to know which worksheet to
pull the data from, based upon the Id contents already in the first column of
each row.

If the cells in row 1 pull their respective data from the corresponding
cells on worksheet "5," and the cells in row 2 pull their data from worksheet
"6," I'm having to manually change each cell's formula to reflect the correct
worksheet ID.

For example:

"='21'!$C$5" pulls the data from a specific cell in worksheet "21."

On the next row, I have to manually modify all the formulas as follows so
they reference the same cells on worksheet "22: "='22'!$C$5"

Since "21" & "22" etc. are already identified in the first column of each
row, is there a way the formulas could simply reference the correct
worksheets based upon the reference in the first column?

Something like: "='worksheet Id in 1st column'!$C$5"

Thanks,

Scott Fraser
City of Key West, Florida