I have created 100 account activity worksheets for each account holder. I
would like to know how to transfer 3 columns to one worksheet in a list.

Example:
Worksheet 1 for Farmer X

Date: Reference: Check No: Amount:

(Would like to transfer Date, Check No and Amount to...)

Worksheet 1 Check Register

Date: Check No: Amount:

The issue is that I need to do this for all 100 accounts. if I just say
=A1, then each of the 100 reports to that column and it keeps replacing. I
don´t have much time to produce this.. HELP!!