Data autofilling from multiple workbooks into one "master" workbook

F

Faith

I keep client records, demographics, invoices, etc, etc.
and use one workbook per client using the different
worksheets like tabs in a binder.

I also want to be able to see a total listing of some of
these items, a master name, address list for example.
What I've been doing is cutting and pasting from the
seperate workbooks to one "master" workbook. It's very
time consuming.

How can I tell each individual workbook to copy certain
fields to the master

and

How can I have it so that the information goes into the
next available empty cell?


Thank you.
Faith
 
Top