Timesheet Problem

[Sirishgreen]

I am having trouble with an excel timesheet problem, Im not even sure which way to go with what im doing, so there is no specific question.

I have about 90 timesheets (workbooks) each containing 12 sheets (months of the year). When the manger sends the timesheet to the payroll department he clicks an email button on the sheet and it copys current sheet into new workbook, adds as an attatchment. All they have to do is send, but this creates 90 emails every month.

I would like to extract the "april" sheet from each workbook and compile them into 1 workbook. So then there is only an email from each manager.

or if there is a better solution i am open to suggestions.

Thanks,
sirishgreen

[royUK]

If all the workbooks are in one folder then you could run a macro to loop through each workbook, open it & copy the required sheet to a master workbook which could then be emailed.

[Sirishgreen]

I will start a new thread asking the question of how to do it.