Create new rows on summary sheet when a new worksheet is added

Hello all

I'm not entirely sure this is possible, but here's hoping.

I have a summary sheet, and then several sheets that are PO specific. What I would like is anytime a new sheet is created in the workbook, the summary sheet creates a row for it based off of the name of the new worksheet. I would also like it to link the same cells each time.

Example:

All PO sheets have the same template for the first 6 rows.

A new sheet is created, called 12345

The summary sheet then adds a row, with column A having "12345" in it, column B have the contents of D2 (from 12345), Column C having contents of D3 (from 12345), and column D having the contents of D4 (from 12345).

I know how to do this all manually, but I'd like for it to do it on it's own, if possible. Is this possible?

Thanks for your time.