Automatically inputting future data

[LPPL]

I have a spreadsheet that is linked to current data in other spreadsheets. How do i make it so when a new spreadsheet is made and data is entered in the future it automatically adds the data to my current spreadsheet.

[Cheeky Charlie]

Have your spreadsheet reference the currently empty cells in the other sheets then when data is added it will show up...

[LPPL]

The future spreadsheets have not been created yet. I need a way so if/when they are created the data in certain cells in the new spreadsheet (they follow a set format so i know the reference for the cells) automatically are inputted my spreadsheet

[Cheeky Charlie]

You can still create the links - they'll just error out.

If you don't want to see the errors you can hide the 'sourcing' cells and reference them with
=if(iserror(<cell>),"",<cell>)

[Zimmerman]

This might get you started. I have a sheet that has tabs for each week of the year. This formula in each cell that i want to reference back to the previous week for a starting inventory more or less. But you just need to make sure that it is a 7 day difference when you rename the tabs. It might be a start.

=(INDIRECT("'"&TEXT(REPLACE(CELL("filename",U8),1,FIND("]",CELL("filename",U8)),"")-7,"m-d-yy")&"'!u8"))

[Cheeky Charlie]

Using indirect will significantly slow the spreadsheet down - and will return exactly the same ref error as referencing directly