Depends on what consolidate means.

If you just want a worksheet from each workbook to be combined onto single
worksheet,

then I'd open both files
copy the used ranges from one worksheet and paste to a new workbook.
then get the second file and copy and paste directly under the first paste.

Or if you're merging fields, you may want to take a look at =vlookup() (if
there's a nice unique key field in both workhsheets).

Hi Douglas

Try Data>Consolidation