Forum Discussion
Msdreemin
Sep 13, 2020Copper Contributor
Help making master sheet
Hi, I have a 50-100 page workbook that I am trying to make a master page for. The first page is the master and all the data needs to be pulled from the other sheets. On the master I need to be a...
mtarler
Sep 14, 2020Silver Contributor
Msdreemin you might be able to use power query to do what you want but I might also suggest you might be better served if you reversed the way you are doing things. Make the master, your master and enter all the data there and then the individual sheets can pull data from the master. In this way you may also find that you don't need 50-100 sheets because all you need to do is create 1 (or a few) templates and then when you fill in which job (or whatever that code is for) that you want to see the information for, the rest of the data gets pulled from the master.