Linking Between Worksheets
 

Hello, I have a relatively large project that I am doing, so individually
linking each cell is very inconvenient. I have one large worksheet with all
the details. However, in the subsequent worksheets I want to take just a few
lines from the first one.; The problem comes when these lines won't transfer
the information becuase the cells have a function that rely on cells above it
(those cells I don't want to transfer, I just want the final average of those
cells, which is what is on the line that I want to copy paste). Is there an
easy way to do this, to just have all the worksheets linked, so that if I
copy paste from the first one, the second page will automatically know which
data it is. Linking the cells one by one is a hassle for large projects such
as this. Any help would be grateful, thanks.