Copying data from more cells (one cell in each sheet) to just one single sheet.

Hello
I've been struggeling with this problem my whole day now, but haven't got a clue what to do.
I got my data in these cells :
A1 A2 A3 A4 A5 A6 A7
B1 B2 B3 B4 B5 B6 B7
C1 C2 C3 C4 C5 C6 C7

(they are placed in excel cells
B2 C2 D2 E2 F2 G2 H2
B3 C3 D3 E3 F3 G3 H3
B4 C4 D4 E4 F4 G4 H4)

And i got these data in 10 sheets, making it 21 cells * 10 sheets = 210 cells
I want to make them into one sheet where all A1 from the 10 sheets would be next to each other like this:
A1 A1 A1 A1 A1 A1 A1 A1 A1 A1
A2 A2 A2 A2 A2 A2 A2 A2 A2 A2
...
....
C7 C7 C7 C7 C7 C7 C7 C7 C7 C7

Is this possible to do with excel?
Hope i asked my question clear enough and that some kind person can help me out
*edit* i got excel 2010

WOW! So fast and works just perfect .. just wow!
Thank you so much for saving me the trouble of having to do this manually all night!