I need a macro that will enabel me to perform the following function:

1. Paste selected data (particular range of cells) from worksheet A
(residing in workbook A) to a new Book 1 worksheet.
2. Paste selected data (particular range of cells) from worksheet B
(residing in workbook A) to the same Book 1 worksheet. This data will be
pasted on the next available empty row below the data in step 1.
3. Continue to paste data from worksheet 3 (and on) to next available row in
Book 1.

Thanks in advance for your help!