You're approaching this from the wrong end. Put all the data in a single
sheet, then use Pivot tables or data filters to isolate the New York, Boston,
or London data. You'll find this is much more flexible and MUCH easier to
maintain.

"Aekta" wrote:

I have a workbook w/three different worksheets. They all contain a column
that has employee IDs each with the same heading. So the columns match, they
just contain different #s.

I want to pull the ID #s from all three worksheets into a fourth "master"
worksheet that will update when new numbers are added to the sheets. (EX:
Sheet1- employees who attended training in Boston, Sheet2 = New York, Sheet3
= London. I want Sheet 4 = list all ID#s from all of the cities. When I add
new ID#s to Sheet 1, 2, or 3, Sheet 4 will update to reflect the new ID#s).

Is that possible?