Autofill Summary macro as new worksheets are added

Trying to write a macro so that my summary worksheet will auto populate when new sheets are added and filled out. I want the PO#, Quanity, Date ordered, Vendor, Subtotal, Tax and Total all to transfer from worksheets like F001 to the summary sheet. Yes there is only one F001 sheet filled out but that number will rise into the hundreds as the project progresses. No idea where to begin when writing this macro. Please help

If you want it to do it automatically whenever anything changes you should use a Workbook_SheetChange or similar type proceedure. This will make the workbook run slower as data is added especially since you would most likely need to figure out what changed in the sheet and what to add.