How do I consolidate columns in multiple spreadsheeds into seperate columuns in one sheet?

[BrettRCourtney]

How do I consolidate columns from multiple spreadsheeds into seperate columuns in one sheet? I've been copying and pasting the data from the multiple spreadsheets into one and that has becomed tedious. I have also tried using the consoditating feature in excel with no luck. There has to be a better solotion. I provided an example of what I'm trying to accomplish below.

Spreadsheet one.png
Spreadsheet two.png
Spreadsheet three.png
Consolidated Data.png

Spreadsheet 1

Coloum A
7
5
7
9
10


Spreadsheet 2

Coloumn A
8
4
7
3
2

Spreadsheet 3

Coloumn A
8
5
3
1
4

Consolidated

Coloumn A Coloumn B Coloumn C
7 8 8
5 4 5
7 7 3
9 3 1
10 2 4

If anyone has a solution, could you please provide the solution in a detailed mannor because I am not an expert with excel.

Thanks,
Brett