I have a work sheet, that is titled "DATA", there are 6 Columns,
consisting of Name, Mon, Tues, Wed, Thurs, Fri.. I have a second
sheet titled "Submit".

I would like a Macro that would match the name from "DATA" and take
the Contents of the cells in that row, and move them to "Submit"
worksheet.

Any suggestions, help, or direction would be appreciated.