I'm trying to link/copy specific rows of data to specific sheets from a main
worksheet. For example, row 16 of the main sheet would be copied to the first
unused row of the sheet specified by the contents of cell A16 of the main
sheet. Contents of row 17 of the main sheet would be copied to the first
unused row of the sheet specified by the contents of cell A17 of the main
sheet. Can you suggest a method to do this?