If I could do this in a simple macro that would be great, but I couldn't think of how. I have a workbook with several sheets that give a user summed up data and charts for visuals. I would like for the user to be able to click a button, and create an exact replica of that sheet, charts and all, but with the charts linked to the new sheet.