Greetings

I'm currently consulting a restaurant management on filing automation.

Currently using excel mac for myself and local management terminals to be using excel 2007 and onwards win 7-8. I'm looking for documentation including basic methodology towards linking excel workbooks (approx. 4) into a capital prime cost, sales and invoices log for the entire management. All remote hosted to the same folder via local network for access via ms home network. Said folder is to be automatically cloned and archived into filing per restaurant cycle billing basis by a foreign file management application.

Essentially requiring four workbooks to be filed into a master sheet for management.

I am new to excel, I assume it may be possible to compile an automated cross workbook actions file?