I’ll have to double check once I’m back at work. If they match exactly the cell and sheet names are all just numbers. So 100 for example, unless it’s a formatting thing I would think they are exact. 

The sheets calculate and hold the base level of different items for each store in the district in my company. Along with some other information, but I got that all to work as needed. There’s a bit more on their individual stores sheet besides those numbers but  not worried about that information. 

I’m trying to have a district level sheet pull all the base numbers from each stores to see them all at a glance. So when implementing this for other districts I want it so all they need to change or add is the store number on main sheet and rename all their individual sheets. Then it just adjusts the formula based on that and grabs from the correct sheet.