I have a workbook with 13 individual spreadsheets for each week of a quarter. The file layout of each weekly spreadsheet is the same. Each week the user will enter a doctor's name and the activities they will do for the week with a particular doctor (i.e. office visit, distribute literature, etc.). Each week may have a different doctor in each weekly spreadsheet. I need a summary page that will consolidate the data collected from each doctor each week and summarized the totals.
I don't think this is a complicated job in Excel but I'm not a programmer and don't write VB codes. I'm hoping that this can be done in an hour or so and I need this to be done asap. I'm hoping you can help me.