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