i need a macro to produce three excel sheets for a data input sheet

hello,

i am new with macros. i have a list of overdue invoices a company needs to pay (refer to data input sheet). I need to to produce three separate excel sheets for payment authorization one to Paul and Steve, another to Paul and Jack and another to Jack and Steve (refer to sheets attached)

Can anyone help with me with a macro? Thanx.