A cell in each row of my "main" spreadsheet (DataEntry) has the name of other
spreadsheets (in the same workbook). For simplicity, assume there are 4
spreadsheets -- named A, B, C, and D.

As a macro loops through the DataEntry rows, it is to copy each row to the
appropriate spreadsheet (A, B, C, or D) based on the sheet name in, say,
column D of each row (of DataEntry).

Using Sheets(?????).Select (if that's what I should use), what is the
syntax for referring to Column D and the respective row? I've tried
Sheets("D" & x).Select . which results in a 'bug'.