I have a file with close to 100 tabs of data. All the tabs have the same type of information in the same places just for different units. I'm trying to create a rollup tab to point to the weekly actual results for each tab. The tabs are titled with the unit number and I have a listing of the unit numbers on the rollup page. Right now I am just using ='tab name'!E6. Is it possible to make a formula that will use column A number to go to the tab titled that number?
A B C
Unit # SALES ACTUAL
54891-000 BUCKS COUNTY CAMPU ='54891-000'!E6
26345-000 FRANKFORD CAMP
Bookmarks