Quickly Referencing Sheet Name

[RSteph]

I’m creating an excel file that has several sheets of site specific information, and then references the information in all of the sheets on a master ranking sheet. There are pretty long formulas involved and there will be upwards of 200 tabs, so I want to write a command that will reference each sheet for the formulas in the rows by text in a single cell, so that the user won’t have to rewrite all the formulas specific to each tab. I’ve attached a picture to help explain. Any suggestions for a command I could use to fill in the sheet name?

[RSteph]

Attachment 588986

Attachment 588987

[6StringJazzer]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.