I have a master list with 40 rows of information and need to copy one row at
a time to 40 different worksheets. For example Row 24 needs to be placed in
worksheet 1; Row 25 to worksheet 2; Row 26 to worksheet 3, etc.

I know how to copy/paste but is there a formula or macro to that I can use
so I am not copying/pasting for a life time?

Thank you