Ill try to explain best I can.

Recently found (finally..) a macro to auto create worksheets named after whats in Column A (5 digit number). I have one master worksheet and now 47 sheets titled with each ID from column A.

Now I have 47 rows with information on the master worksheet and 47 empty worksheets.

How do I put each row into each worksheet? ... Worksheet one will contain row 2, worksheet 2, row 3 etc etc.

I should also mention that row 1 is the header(?) says the titles ...that should be copied in addition to each row.

make sense?