I have a problem that I'm not sure CAN be solved. I'll try to
describe it as best I can.

We have a four sheet workbook, all with the same column headings. The
first three are used by three different sales managers to record each
vehicle they sell and the details of the sale. The fourth sheet is
the problem. We want Excel to automatically collate the information
from those other three sheets - not a summary or total, but actually
a complete list of the sales from all three sales departments.

I hope that makes sense! Can it be done? I have NO idea about VBA, so
if that is involved in the solution, I will probably need to be
walked through.