Consolidating Data with three Columns

[howard]

I have four spreadsheets that I want to consolidate into a sperate workfile. There are three columns

1) Account Number
2) Decription
3) Amount

I want all three to appear on the consolidated report. At present I can only get the account number and the amount to appear on the consolidated workfile.

How can I can the descriptions to appear as well.

Howard

 

[JohnnyTightlips]

How are you getting the Account number and Amount onto the consolidated sheet?