Hi and thanks in advance. In anticipation of having to merge a couple of
worksheets (I will have a choice about whether these will be in different
workbooks), I created two "TEST" worksheets in two diff. workbooks..filling
in just a few cells, but naming the columns the same.

I looked under the tools menu. The "Compare and Merge Workbooks" command is
not active... any ideas?

Depends on what you exactly mean with consolidating. You could copy/
paste the data and use a pivot to get your report. Otherwise look up
the Data/Consolidate function in Help. It might be the answer to your
problem

DQ