How do I insert address data from a column labeled Address ie (123 Main St.) from workbook A, one cell at a time into a cell in another excel file (let's call it Workbook B) and and auto print each sheet with the address data until all the addresses in the column have been printed?

Example:

Workbook A Data

Address
501 ADDISON AVE
1025 APPLECROSS DR
443 ASH ST
2301 BARNWELL LN
2305 BARNWELL LN
256 BLACK WATER LN

Workbook B Results

(Cell A1 data) ADDRESS
(Cell B2 data) 501 Addison Ave then print
(Cell B2 data) 1025 Applecross Dr then print
(Cell B2 data) 443 Ash St. then print

And so on, until all the addresses have been printed automatic.

Thanks in advance for any help for this Excel novice.