Hi

I have a workbook with about 100 sheets; they are all formatted the same as
far as rows, columns, etc. The data in the cells is different.
I would like to copy a range of rows based on the contents of a cell on the
worksheet.
To further explain, I have one of three possible values in cell A1. Based on
this value, I want to copy the range of A5:M13 to another sheet, named the
same as the cell.
I need to repeat this process for all of the sheets in the workbook.

I would like to automate the process because the sheets are going to be
updated often, and I would need to revise this "summary" page after the
updates.

Any assistance is appreciated.
Thanks