@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.
