I have a multiple data sheets. There are data in row 1

I need the data in row 1 to be copied over but there are so many row
in different sheets. How can i copy all row 1 over i.e sheet2 row
would be in row 2 since row 1 is occupied

--
Message posted from http://www.ExcelForum.com