Linking Spreadsheets

[Rita]

Please Help!!!

I have linked to workbooks the linking workbook has specific worksheets
in it. What I need to do is change the row from the worksheet when I
copy to a new column in the linking workbook without changing the
"worksheet name"

link looks like this

ie: '[gravel.xls]sand'!$L$20*G4

Workbook = gravel
Worksheet = sand
L20 = Column and row of above

*G4 = Column and row of current workbook

What I would like to do next is have excel lookup the next set of
totals from column "L" changing the row only.

Is this possible??

So far I have gone in the worksheet did a copy paste the manually
changed the row.

Thank You
Rita