M
MRSVATEK
I have 100 sheets with the same layout that I want to summarize on a master
worksheet. The cell references are the same on all 100 sheets so it is easy
to link the data but I dont want to reference or change the sheet name to get
each line of data.
Can I name the sheet with a text string that is on my summary worksheet and
have a formula look for that sheet and pull the data in the referenced cells.
worksheet. The cell references are the same on all 100 sheets so it is easy
to link the data but I dont want to reference or change the sheet name to get
each line of data.
Can I name the sheet with a text string that is on my summary worksheet and
have a formula look for that sheet and pull the data in the referenced cells.