I have a personal workbook with all my macros so that I can use the macros in any workbook. In addition, I have a workbook that I use daily at work. I use this workbook and resave it under different names for each client I am working on. I have since decided I want to add a new sheet to this standard workbook that summarizes information from other sheets in my standard workbook. However, I don't want to recreate this sheet every time. So I thought maybe there is a way I could just copy the sheet into my Personal macro workbook, and then use a macro to copy this sheet from my personal macro workbook into a new sheet on the active workbook I am using. How might I go about doing this?

Thanks for any ideas you might have.