Transferring data from multiple worksheets
 

I have 4 worksheets that I will using (1,2,3, 4). I want to pull/transfer
data from either worksheet 1 or 2 into worksheets 3 & 4. Data will never be
entered into both worksheet 1 and 2 at the same time. I'm a novice at excel
and not sure if this is understandable. Please let me know if you need
further info. I'm using '97.

Thanks!