Google Sheets: Merging several live schedules to show what is due this week

Hi all,

I am working in a fabrication business who have several different customers. At present we have live spreadsheets using google sheets for each customer. However I would like to pull these all together to provide a 'master schedule' as such so that we can see what is needing done for the current week/ 2 week period.

Im guessing this can be done via some sort of LOOKUP but not sure how this work with live sheets.

Any help is much appreciated.
Thanks
E

You don't provide many details, so I can't offer more than generalities as a response.

See this Google Sheets workbook. It pulls in data from 3 other Google Sheets workbooks by using the importrange function. This shows only the basics of how to do this, but to repeat, generalities are all I can provide given your lack of specifics.