Frank, I'm not sure what you mean. Perhaps I confused you. I'll give you
more information.

The information contained in each of the worksheets needs to be kept
separate with periodic exceptions and I have one of those exceptions
happening, now. It's a contact list used for merges with Word.

The task at hand is to send Christmas cards out. Therefore, I want to merge
all of the lists at one time, but it would appear that the only way to do it
is to put them all into one list before I do the merge. Does that help you
or confuse you? Diana

"Frank Kabel" wrote:

Hi
better would be if you had only one master sheet. any way to change
your spreadsheet layout?

--
Regards
Frank Kabel
Frankfurt, Germany

"Cowtoon" schrieb im Newsbeitrag
...
I have several worksheets in a workbook. I'd like to pull all
contents (from
all worksheets) into one worksheet, while leaving the other
worksheets in
tact. Is there a way to do that. The other worksheets will change
periodically, so it has to be setup to allow for those
changes/additions. I
have no idea how to approach this or what to look up to find help.
Any
thoughts? Thanks.