Question: how to copy data from multiple sheets to one sheet in excel 2007?
Answer: Select the range in current worksheet you will copy and paste into multiple worksheets.
Go to the Sheet Tab bar and select multiple worksheets (including current worksheet) you will paste the data into. ... 
Click Home > Fill > Across Worksheets.