Hello,

I have a workbook comprised of about 400 worksheets. I also have a summary page that lists tons of information that I need to automatically be sent to its respected worksheet. On the summary page I have the list of worksheet names in column A starting with cell A3. I am trying to get everything in that row to go to each specific worksheet. Is there a MACRO I can use to do this? Thanks for the help guys!!

Example

Tract date comments

1A 10/21/2013 No Comments
1B 10/21/2013 No Comments
1C 10/21/2013 No Comments
1D 10/21/2013 No Comments

worksheet names summary/ 1A/ 1B/ 1C/ 1D/