Macro to copy row to specific sheet in closed workbook

I have a spreadsheet with values in columns A-F.

In column A is a closed workbook name/directory path.
In column B is the sheet name within the workbook specified in column A.

I need a macro which will run with a SUBMIT button in column G which will write all row values in columns C-F to a new row in the worksheet specified by A and B. Any further additions should be added to the next available row in the specific worksheet without overwriting previous data.

Thanks
Phill

Thank you for the reply. The workbook can be opened and closed (if this is done immediately), but preferably it would be done without opening and closing.
Also is there any way of deleting the row from the original sheet once it has been copied to the new sheet so that fresh data can be added?

Thanks, but it doesn't seem to write to the Target workbook? I click submit, but the data disappears from the Source workbook, but isn't on the Target.

Yes, I didn't change anything other than the file path to suit my PC, click submit, it deleted data in Source, and Target was unchanged.

Thanks for the update.

Cells C3-F4 are selected in the target file (this was happening before also).

The source rows aren't deleting, however the target file remains unchanged when the submit button is clicked. I also tried adding data to the source file in row 10, clicked submit, and again no change to the target file.

If it's easier, we can limit the input of one row at a time before clicking submit. Ideally we would want the source row to be deleted once it's been transferred to target.