Macro to loop through a list to create documentds

would like to script that would loop through a list of invoice numbers on one excel tab and

find the row with the invoice number on a different large tab (same excel file) sheet.
It would then copy the entire row to a specified blank tab.
open a separate spreadsheet (invoice template) and copy parts of the row to it
save the template with a new name containing the invoice number
go to the next invoice number and repeat