Consolidating data

Hi Linda,
I hope you don't mind me answering on Rajeev's behalf.

Presuming the data does not change on sheets 1 or 2, and perhaps only changes on sheet 3, I think the answer to this may be relatively simple. On the worksheet where you want to hold the entire list of 150+, set the headings to mirror those of the other worksheets. Then in the first blank cell, type and equal sign, then use your mouse to choose the first cell with data in the first worksheet, and hit the enter key. You can then use your mouse to copy the data down and across (hover your mouse over the bottom right of the cell that you want to copy, until your pointer becomes a plus sign, then click and drag your mouse down, and then across). Once you have copied the data from sheet 1, you can start at the first blank cell, and copy the data from sheet 2 in the same manner.

Will this help with what you are trying to do? If it doesn't, please feel free to reply to this message with any further details you may have, and I will be glad to assist more. If it does resolve your question, could you please mark your question as "resolved"?

Have a great day.

Kind regards,
Mara
Microsoft Office Specialist Master Trainer