I have a spreadsheet for each on-going projects and one summary
spreadsheet.

Each time I create a spreadsheet for a new project, I have to go back
and forth between the new spreadsheet and my summary spreadsheet and
go thru the "=" and "Enter" process for each cell i want to link to.

All the cells I want to link to are in one block (row) and I tried to
do the "= and Enter" thing for just the first cell and highlighting
the whole block i wish to link to but it only does a straight copy...
no link is created so when i update the cells later on... my summary
is not being updated.

Any way of doing the linking in one step?

TIA