I have an Excel spreadsheet that has contains my employers staffrosters, there is one duplicate spreadsheet for each of the many work locations throughout the country, how could I best collate all the data and rosters for each site so I could then effectively manage rosters throughout moving staff where necessary to ensure safe staffing levels across the all the locations, so in essence what would be the best way to approach this? meaning ..My initial thoughts are should I create a Master sheet linking to the DataSource's (sounds cumbersome though) of each spreadsheet (which stay on a document server) or just migrate all the rostered data onto a server and storing all data on something like SQL Server or what do you suggest! would be the most proficient approach, I already began writing VBA to collate the data from each into the one sheet, but then I thought I'd better get some more opinions before getting into the nitty gritty.
