I have a big spreadsheet which tracks my construction budget for a tv show i'm working on. I have a summary sheet which references set estimate breakdowns that are contained as seperate sheets in the same book. each of these sheets is named by number (1, 2, 3, 4, etc.). Each of these pages are exactly the same, so if i want to reference cell b1:h1, i know the set name will show up for whatever sheet i'm refferencing. I'm wondering if there is a way to use the information in a cell on my summary page as the name of a worksheet so I can copy and paste my formula rather than going in and manually changing the sheet reference?
for example
='3'!$B$1:$H$1
this is what is in there now, and I have to go in and change the '3' to '4', '5', and so on and so forth. I need to create a new sheet for each episode and this task is becoming quite daunting. is there a way to reference it like this?
cell b3 = 1
='b3'!$b$1:$h$1? I know that doesn't work but i'm hoping my examples and rambling will help with an answer. Thanks!
Bookmarks