Generate separate excel sheets for each row of data using vba

[jessicapiper]

Hello,

I have a spreadsheet with rows of data. I want to generate a separate sheet for each row of data. I want the name of the sheet to come from the data in column A. I want the data in the other columns to populate cells in the new spreadsheet by reference, so that when I update the master spreadsheet it will feed the new individual sheets. I've searched multiple forums, websites, etc. and can't seem to find the right macro to work with my situation.

Thank you for your help!