A macro would be easy to create though I don't think it is necessary.
You have a number of options, some of the easier ones:
1. right click on the tab with the information you want to copy and select
'move or copy', select the other workbook and 'copy'. This is make a copy of
the entire sheet.
2. You could copy and "paste as link" if you want changes to update
automatically.
3. For writing a macro, try doing a record macro in target workbook, select
the information in the other workbook and select copy; go back and paste then
turn off the record macro. Then go and read the macro information in VBA (Alt
F11)
