User Selectable Range

Is there a way to create a macro where a user selects a certain row of data as the defined range and the values in certain columns of that row get pulled over into another sheet in their respective cells?
The attached spreadsheet is pretty basic. For example I want the user to select row 2 for example, and take the value in column A and put in the respective cell in the Cover Sheet tab, and the value in column B in it's respective cell, etc. There's a lot of other data involved, but once it's started I'm sure I can figure out the other pieces.

I appreciate your help in advance.

There's going to be mulitple invoices with the same ID so dollar amounts and payee would be different in multiple cases. Plus what I was getting at is for a macro that allows the user to select multiple rows of data and create multiple cover sheets(tabs) per invoice. I'm not very good with looping, so I was trying to see if it could be done using just one row of data first.

I've attached another spreadsheet with more specific examples. I'm looking for something that would create a cover sheet for each individual row. Is it possible? Thanks again for your help.