How to create a summary sheet that will auto-populate as new tabs are added?

Hi all, first-time poster here. Thanks in advance for any advice you may be able to offer.

I have a database project in which I have several tabs. Each tab is specific to a project site, and each tab is formatted identically. I would like to create a summary sheet on a separate tab at the beginning of the workbook which will pull information from select cells on all the other tabs and auto-fill as new tabs (sites) are added to my database.

For example, the summary sheet should have a column for each of the following parameters (which occur in the same cell on each "site" tab):

Site ID
address
street name
category
recommendations

Each site (again, on an individual tab) would then fill in a row on this summary sheet. I would like this summary to auto-fill the information in a new row for each new "site" tab added. I have a hunch this is a macro/coding issue, and may be in over my head. Any thoughts on this? Thanks again for any advice offered.

If you wanted it to be fully automatic, so that the data appeared as soon as you added a new sheet, then yes, you would need a macro solution.

If you wanted to avoid macros, then it would not be very much trouble for you to manually add the new sheet name to a list on the summary sheet and for the data to then appear automatically. You would need formulae which would make use of the INDIRECT function to bring data from the appropriate cell in the appropriate sheet.

Hope this helps.

Pete

Thank you Pete for your time and the quick response.

The end client for this database will be a municipality where several people with varying levels of expertise, ranging from fairly competent to virtually computer-illiterate (like me!) may need to add new sites. Even the idiots (like me!) should be able to add a site by simply copying a tab and updating the appropriate info, but would be nice to cut out the step where they would also have to remember to update the summary sheet. So yes, a macro would be ideal.

I have seen on some of these forums macro code for similar operations, although I am not in the know enough to decipher which pieces of code need to be adjusted to fit my application. If you or any other users have a an example (something where one cell from an indefinite number of tabs is copied to this auto-fill summary sheet), I may be able to run with it from there by simply adding and adjusting cell references.

What I would love is this: a piece of code that basically says, "take data from cell A3 on each tab and add to column B on "summary!" tab". If I had that, I think I could add to it to grab data from the rest of the applicable cells and add to the appropriate row on the summary.