Hello,

I was trying not to start a new post because I found many examples here of what I need to do. However, I don't know VBA so couldn't figure out how to modify the code to match the cell address, etc, of my workbook.

I have a workbook with 100 sheets named sequentially L1 - L100. Each sheet has cell I2 which contains a name. I have an Index sheet which is already formatted with 4 columns of 25 spaces to accommodate the names A2-A26, D2-D26, G2-G26 and J2-J26.

Is there a way to pull the associated data from cell I2 in each respective sheet and get it into those respective cells? Also, if a name in I2 gets changed, can it automatically update its respective entry on the Index page??

Thanks in advance for all your help !!!!