I have 2 workbooks, each with multiple worksheets. I need the data from
workbook 1, sheet 1, to be automatically transferred to workbook 2, sheet 1
when entered, and so on......

How do I do this?


Thanks in advance.