Quote Originally Posted by learningbasics View Post
Thanks for the reply! The problem with the attached is that your table on the summary sheet is assuming I will only have the three sheets, if I was to add a budget 4 sheet I don't know how that would work.

Also thank you on your notes about databases, It's on my list to understand - but on this particular case there is a lot of information that needs to go on each sheet, and that need to be kept separate at the request of the project manager. I can keep them all separate with a lot of manual links and inputs, but I'm trying to avoid manual inputs because that increases the chances of the spreadsheet failing!
The intention was that you would merely list all your sheet names across row 3 of the Summary Sheet. Then copy and paste the existing formula to fill up the whole matrix.

I hear what you say about the separate sheets but rather than expecting a manager to find a particular sheet amongst a lot of tab names, a smarter way of operating would be to have a template that fills up from a master database when the project manager selects a particular job from a drop down cell.