Summary Page

ianfourie Rather then answering your question, I would suggest that you change the approach to the issue. It's not very effective to use one sheet for every part (you currently have 83 such sheets) and roll these up to a summary report. Begin by creating a parts list that contains the header information that are now spread over 83 sheets. It could look like this:

Then, record all transactions in one table. For instance, like this:

..... and use built-in functionality (a pivot table) to summarize the transactions and combine it with parts information.

Now this is just a very crude example and will probably have to be re-worked quite a bit to make it work four your particular situation/needs. And if you are not familiar with pivot tables and the Data Model, it will take some learning. But, in the long run, it will be easier to use and maintain than working with one sheet for every single part number.

You'll find source for the screenshots in the attached file.