Hi:

I have a workbook with about 250 worksheets, let's call it MW.xls. All worksheets have a name(a1, a2, etc). Once a week I copy groups of worksheets and save them as different workbooks(let's say wb1.xls, wb2.xls). Those workbooks get updated and emailed back to me. I receive about 15 workbooks through email.

I need to copy different cell ranges from the updates workbooks' worksheets (let's say from wb1.xls) to the original one(MW.xls). So if in the emailed workbook I have worksheets a1, a2, a3, I need to copy cell ranges b5:k5 and a7: j10 to the same worksheets in the original workbook(MW.xls).

It is a very tedious process and it is identical for every sheet.

Thank you in advance for any help,