I need help numbering items sequentially across multiple sheets

I'm currently working on a template to create submittals of our products. I'm trying to figure out how to number the selected parts sequentially across multiple sheets, based on the table of contents, across multiple tabs. Preferably using a formula...

My master sheet is labeled "Start Here." So basically, when you double click on a cell in column "A" on the "Start Here" tab it changes from a 0 to an "A". The formulas on the tabs labeled "1", "2" read from that "A" on "Start Here" and highlight the appropriate part. I have simply typed in the numbering sequence that is desired into column "B" next to the part. The numbering needs to be sequential across multiple sheets...say 60 or so. So it all stems from "Start Here." After the items are selected it should auto number as they are selected or possibly a macro button called "Number Items" which is tied to VBA??? The last step is the "Delete Worksheets" button which is tied to a macro called "sheetsbegone." I will then set the Print Area and print multiple worksheets to PDF. I hope that makes sense.

I have figured out how to highlight the required part(s), but also need to number these highlighted parts sequentially, based on the table of contents, across multiple tabs. Preferably using a formula...

Any ideas??

Thanks in advance for all your help!!

Dflak,

Yes, you are on the right track for the most part. The numbering needs to match the "table of contents" or list on "Start Here" across multiple pages. Attached is a complete list. So some of the similar items will be combined on one sheet like they are on Sheet 1 or 2. But in the end there will be 30 or more sheets of components.

To answer your question, the numbering sequence should reflect what is on the "Start Here" sheet as that will determine what sheets will be deleted with the "Delete Worksheets" button. The formula or macro will also need to account for the random selection of parts as it will change every time. Does that make more sense?

Thanks for your help!!