You don't have to copy to do that. Set up a series for each sheet's column
=Sheet1!$A$1:$A$10
=Sheet2!$C$1:$C$10
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Majeed B" wrote in message
...
Hi,

For Excel 2007, In one sheet I have 60 columns and I have 5 different
sheet
with same no of column. I want to make a graph (basically 60)
corresponding
to each column in the 5 sheet.
So make a graph from sheet 1-5 of column A, B,.... XX
Can anyone suggest a marco to do all this in one go

Thanks