Can anyone help me?

I have a workbook with a number of worksheets with contain data and a chart
based on some of the data. I want to be able make a create a worksheet that
contains only a linked picture of the charts on the separate workbooks.

The only way I've been able to this up to now is by copying the chart to the
clipboard, pasting it in powerpoint as a linked picture and then moving that
picture back to excel.

Is there a simpler way of doing this?

Any help is much appreciated!
Bert