I put up a post the other day, but I think that I complicated my question
too much. I'll try again as follows:

I have two worksheets, one of which is a shorter version of the first. For
example, let's say I have 12 columns in Worksheet1, and 9 columns in
Worksheet 2 which have
the same data as W1. In other words, W2 uses 9 columns from W1, but not
necessarily columns1-9, it could be the 1-6, 8, 11, and 12 columns from W1,
but the ones that I want transferred to W2 have the same column headings.

What is the basic procedure that allows me to work with W1 and have the data
entered also be transferred from W1 to W2 without me having to go through a
tedious copy/paste process?

Is this synchronization?

I hope that the above explanation is clear enough.

Thanks
Lewis