Exporting sheet objects from multiple sheets into same excel

[#1]

Hi,

How to write a macro for exporting sheet objects from different sheets to same excel

example:

Chart from sheet1

Table Box from sheet2

to same excel file.

It will be more helpful,if you provide me an example macro.

Thanks