Hello Danger DJ
can you use something line this
Refer to the same cell or range on multiple sheets
A reference that refers to the same cell or range on multiple sheets is called a 3-D reference.
Click the cell where you want to enter the function.
Type = (equal sign), enter the name of the function, and then type an opening parenthesis.
Functions that can be used in a 3-D reference
SUM - adds numbers
Click the tab for the first worksheet to be referenced.
Hold down SHIFT and click the tab for the last worksheet to be referenced.
Select the cell or range of cells to be referenced.
Complete the formula, and press ENTER.
example:
=SUM(Sheet1:Sheet3!A4) This sums across sHeets 1 thru 3 ,,,,just put the formular in a new sheet and copy the formular down
does this help
pll