Need help numbering sequentially across multiple sheets

I'm currently working on a template to create submittals of our products. My master sheet has a list of all parts that once selected become the table of contents for the final submittal. The remaining tabs in the spreadsheet contain a picture of the part, product details, and a list of variances of each part. For example one part may have 10 variances. So the part that is required is on my master sheet in the table of contents. In some cases one tab may have 3 or 4 parts on it.

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!!