Thread: putting a chart and two graphs onto a new sheet

I've been trying to set up a macro that can take a chart and two graphs and copy them onto a new sheet. The table and graphs can be changed through pull down data boxes, so I need to be able to repeat the action a lot, but since I can't just copy and paste all three at the same time, I cannot for the life of me get the macro to make them all on the same page after the first time it is run. The first thing (the chart) I copied and pasted when making the macro always goes onto a new sheet, sheet 2, sheet 3, sheet 4, how ever many times I run the macro, but the graphs always just paste over on sheet 2. If I was able to just change the spot in the code where it pastes the graphs to sheet 2 to just paste in the most recent sheet, the problem would be solved. But I don't think its that simple. I know my explanation of the problem isn't the clearest and I can't post the code I have so far til tomorrow, but any ideas? any help would be much appreciated