I have tried various codes given out on this site already with no luck. I am
able to change the name using the most basic of code and assigning a value,
however I need the worksheets to pull from multiple cells in a worksheet.
Basically mirroring the name of the data within. I would prefer the most
basic of codes as I am not familiar with this. Can anyone help? thanks