Can anyone please point me in the right direction for a method to perform the following action(s).
I have a workbook with several (and I mean A LOT) worksheets contained within it.
Each of these worksheets has an identical layout, but with different information contained within it (invoices).
What I am looking to do is to create a summary page that can reference each of these worksheets dynamically to sum the various amounts contained within them.
This needs to be done dynamically as I will be constantly adding new worksheets, and don’t want to have to update my summary page formulas every time I need to print an analysis for the data.
I’m assuming there will be a fairly straight forward VBA solution to this, but I don’t have a clue where to start.
I have a workbook with several (and I mean A LOT) worksheets contained within it.
Each of these worksheets has an identical layout, but with different information contained within it (invoices).
What I am looking to do is to create a summary page that can reference each of these worksheets dynamically to sum the various amounts contained within them.
This needs to be done dynamically as I will be constantly adding new worksheets, and don’t want to have to update my summary page formulas every time I need to print an analysis for the data.
I’m assuming there will be a fairly straight forward VBA solution to this, but I don’t have a clue where to start.