Linking a sheet up to multiple worksheets

[olimajor123]

Hi there,

A theoritical question as I don't actually have the worksheets yet but is it possible to link a cell up to multiple cells on different workbooks if the workbooks don't exist yet?

Ie - I want to have a master spreadsheet that tracks the hours people work from their timesheets but they will be creating timesheet workbooks each week. Is it possible to have it automatically update on the master sheet if the timesheet workbooks are all in the same folder/location?

Thanks