Find and update multiple sheet tabs with new data based on range of cell values.

I'm a little unclear, but what does make sense is a few functions you can build on in order to accomplish your tasks. So how about:
1: A Function to return a sheet, based on a string input (the name of the sheet)
2: A Subroutine to call that function for each cell in range (i12:z12) that contains content that exactly matches a sheet name in ThisWorkbook
3: A Subroutine to change the name of a worksheet
4: A Subroutine to copy content into that/a new worksheet (input1: Worksheet To Copy To, input2: Worksheet To Copy From)
5: A Subroutine to delete a worksheet based upon the worksheet name passed to the subroutine

...and then just put it all together, in the scope of a subroutine that utilizes each building block properly.

1: A Function to return a sheet based on a string input (not debugged):

Please Login or Register  to view this content.

Note: Will return Nothing if no sheet found so code this function is called upon may need to consider that

2: A Subroutine to call that function for each cell in range (i12:z12) that contains content that exactly matches a sheet name in ThisWorkbook

Please Login or Register  to view this content.

Don't use my code until you can use code to do what you want to ONE worksheet.

Focus on the problem by forgetting I ever wrote that code and write code to operate on one worksheet -- the only thing I omitted b/c I was not clear what you wanted.

Even if you can't get the code write, write out what you want to do with pseudocode/descriptions broken up into several steps.



Note: Ignorance isn't an issue if you ask the right questions.

For Instance:

Store Worksheet Named "XYZ" into variable wsSheetToCopy_From
Store Worksheet Named "UVW" into variable wsSheetToCopy_To
Copy All Content from ws..._From to ws..._To

...or

Store Worksheet Named "XYZ" into variable wsSheetToCopy_From
Store Worksheet Named "UVW" into variable wsSheetToCopy_To
Copy All Content from ws..._From to ws..._To, excluding rows 1-15, etc.