I am using Excel 2002 and have a workbook with several sheets that I
need to combine into one list. The data I need to combine is located
on the same place on each sheet; however, one potential wrinkle is
that the data is non-contiguous (i.e. Name is cell B7, Salary is in
cell D10, etc.). This may be able to be done without using VBA;
however, the consolidate feature does not seem to produce what I want.

Any ideas?

Thanks,
Brent