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.