easy option, you create a dummy worksheet to put everything from the employees worksheets. Then, in each doctor's worksheet, you make a vlookup to the dummy worksheet.