Linking two Google spreadsheets

Using the =IMPORTRANGE() formula, you can link the content of one Google spreadsheet to another.

The trick is getting the "spreadsheey key", it the stuff between the last two slashes in the URL of teh page you're linking to. Remember to put quotation marks around it

Next, you need the cell address(es) INCLUDING THE SHEET, again with quotation marks around it.

Then click on the REF# and allow access