Summary Sheet - Using data from multiple sheets

Hello,

I've been trying various things to get this to work, but I’m not having much luck.

I have a spreadsheet that will be used to track how much time is being used on different jobs and how much time is left in the budget for the job. It's being used to see which employees have been working on each job and how much time they've put into it.

The idea is to have a new tab for each job and have a Summary Page at the front which will show just the Job Number in one column, Hours used in another and Hours left in another.

I would also like to make it automatically add new jobs to the summary page when a new tab is added (as new jobs are added regularly).

I've attached the file, so you can get a better idea of what it is i am trying to achieve.
Attachment 391963

Hi,

Please attached file again as it is not uploading giving the error.

Thanks
Nisha