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

Hi there... and welcome to the Excel Forum.

Please attach a sample workbook. Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary. Remember to remove ALL confidential information first!!!

However, nothing on this Forum works quite as well as you might expect. The attachment icon doesn't work!! (Helpful, isn't it!!). Instead, just before you submit your post, click on GO ADVANCED (near the bottom) and then scroll down to Manage Attachments to open the upload window. The relevant instructions are at the top of that screen.

There's a fair bit of "stuff" here. What do you want done and where should it be done? For example, you talk about a master sheet, but there's no sheet called Master....