First, let's get the terminology right.
A file is called a workbook
Tabs within are called worksheets or sheets.
What is your layout and what is the common field.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"jjacksonn1966" wrote in message
...
I have 2 different spread sheets with one common field. I want to combine
the
two sheets together to have one sheet which has the data from only the
common
field combined. Can someone help with this.