Oh yeah...sorry about that. 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.
Bookmarks