Hi all

I am trying to create a formula that will gather information located on
different worksheets. I am trying to do this dynamically by creating a
macro that will "rebuild" the formula after a new sheet is added.

The data is located in the same cell on each sheet.

I figured that I could write a for next loop that will parse through all the
work sheets and add the cell to the formula.

I am not a super programmer but I can get by so if someone can point me in
the right direction, I would appriciate it very much

thank You.


--
Mark Smith
SPX Air Gage Co.