Copy named rows based on new sheet based on text comparison of two cells

[rdoulaghsingh]

Good day everyone! I hope everyone is doing well.

So here's what I'm trying to do...I need a VBS that will loop through a workbook of multiple worksheets and look at columns C and D for differences as long as the text does not match "Default settings" or "Configurations settings". If there are differences between the two columns, I want to:
1. copy the name of the worksheet tab starting at A3 on a new sheet called "Change List"
2. copy the row (only the first 4 columns) from the worksheet being compared and place the entries in B3, C3, D3 and E3 respectively on "Change List"
3. Recurse this action throughout the entire workbook until all differences are recorded from step 1 and 2 above in the "Change List" rows

Any help would be greatly appreciated. Thanks in advance!

 

[My Aswer Is This]

This here is still hard for me to understand
and look at columns C and D for differences as long as the text does not match "Default settings" or "Configurations settings". If there are differences between the two columns, I want to:

So if column C says "Alpha" and Column B says "Bravo" Enter the sheet name in Column A of sheet named: is that true

If not give me a example of when you would enter sheet name and when you would not

 

[rdoulaghsingh]

I guess I miss read your original post.
I'm going to have to let someone else here on the forum help you.

No worries. Thanks for all the help so far. You've provided a good foundation.

 

[rdoulaghsingh]

This here is still hard for me to understand
and look at columns C and D for differences as long as the text does not match "Default settings" or "Configurations settings". If there are differences between the two columns, I want to:

So if column C says "Alpha" and Column B says "Bravo" Enter the sheet name in Column A of sheet named: is that true

If not give me a example of when you would enter sheet name and when you would not

Good morning @My Aswer Is This. I've uploaded a screenshot of what Column C and D look like. You can see that there are multiple row instances with headings "Default settings" and "Configuration settings" going down those columns. I don't want to capture those rows - I want them omitted from the copy to the "Change list". I just want to output a clean list of the variances of every other cell without those titles.

Secondly, if Column C says "Alpha" and Column B says "Bravo" copy this into it's own row starting with the worksheet name in Column A of "Change List" sheet. Then take Columns A B C and D from the sheet being compared and copy those to Columns B C D and E on the Change List.

Third, I understand performance might also be an issue here. Looking at the code, is it going down the entire range of rows on each sheet?

 

[Sean Jines]

I have something along the same lines, But Different. More Date Mining though. This Will be to pull data from Multiple data sources, But once I have one I can Manipulate to the rest.

My Workbook "My Overview" will be open, Need to Open the second workbook "MMU Ping Failure"​

Compare the first column with Header to the first Column in the second workbook. If Second workbook has a new value add the value to my first column, without deleting any my workbook values​

Insert a Formula in My workbook second column to Pull data from source workbook, copy formula through columns to the right the down to the last row​

Copy values from the formula and paste them so that My workbook cells only have values.​

May need to do this for multiple tabs in the Data Source.​

Close Data Source "MMU Ping Failure" Workbook.​

​

I am familiar with VBAs but last few years I have been using 365 and did not need near as much, but bus laptop going back 2016 version and bogs down easy.​

If you could just give a ' line where my input is needed, thanks.​

​

Below is an Example of Files​

​

​