I have a worksheet (Register) and need code to open a worksheet based on the value in a cell (D12:D26) and then loop to the next empty cell (A1)

[J15491]

I have a workbook with 5 worksheets. I have the code to bring up the appropriate worksheet based the value Column D (Cell D12). I need vba code to copy and paste information from row 12 to the activated worksheet, print 2 copies, saving a copy to a specific folder and then return to the next empty cell in the original worksheet repeating the same process as I enter information in the activated worksheet. Continuing the process through the rows until I have have row 26. I have searched a number sites to work this out, not finding everything I needing to complete this process. Any help will beappreciated.