I have read several threads and have found some close examples but I need more help. I have about 70 agencies that need to fill-in a time sheet for reimbursement. Each agency will vary on the number of time sheets submitted. I want a button that will open the time sheet, rename the tab TS1 and allow the user to fill-in the appropriate data. Now the user needs a new time sheet, presses a button and gets a new time sheet, fills in the sheet, and renames the tab TS2 and so on. When the time period finishes, I want a sheet that summaries the individual time sheets. For example, from the time sheets I want the date, person's name, hours, and rate to appear on a summary sheet. Each time sheet needs to printed and signed by a supervisor. The summary sheet needs to match the number of time sheets (this is being done manually). Is there a way to generate the summary sheet as the time sheets are created through the time period? In some instances, it could be 50 time sheets from one agency. The spreadsheet would have the summary sheet, and possibly 50 sheets with tab names TS1-TS50. I would want to protect the summary sheet.
JAM
JAM
