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