I am trying to creat a series of tabs with source data that will be collected
into the final tab into an all up spreadsheet.

Various groups of people will select thier tab, input thier data and Im
trying to get the final tab in my spreadsheet to go collect that source data
and bring it to a final spreadsheet on the final tab. I understand how to use
the formula to identify the cell in the source data tab but my problem is the
people adding their data MAY ADD ROWS, thus messing up my formula on the
final spreadsheet.

Is their a formula that will allow for the adding of rows in the sorce tab
so that it still pulls the data onto the final tab? As it is now, when they
add a row on the source tab, that data isnt being picked up in the final
tab...

thank you
Heath Taubitz
Lockheed Martin