One macro to open multiple workbooks and sheets issue

Hello,

I just wanted to Thank You in advance for reading and possibly helping me. I have some knowledge of VBA but I have issues figuring out the intricacies unless I am modifying an already existing code. I am learning.

I have been trying to get a macro that will open a different workbook, find the sheet, insert a blank range, copy data from row above and paste it is a value in the newly created range. This macro will need to repeat this in about 11 workbooks with multiple sheets in each. I have attempted to do this with macro recorder and creating a few objects but I am running out of luck when it attempts to switch to the next workbook and change sheets. Above that... I know there must be a better way as this seems to be very manual and the code will be super long when its done.

I have included a copy of a mock up for what I am attempting. It consists of 3 workbooks. The main workbook has the macro and the other two will be the ones modified. Again, it will need to do this with about 11 workbooks in the end. Changing the VBA script to the location you saved them should work and you can see what my problem is.

Any help at all would be very very appreciated. I am learning but I am still using macro recorder as my primary means which is probably the issue in itself.

Thank you for reading.

Thank you for sending this. The sheets are based off of the names, essentially the first sheet does not need to be included. No reason for that code to be reworked though. It works super fast and I should have no problem making it work. Thank you so much. You saved me tons of frustration and time with a much better code.

I do have a question though just for my own understanding of VBA. "strPath = ThisWorkbook.Path & "\"" What does this actually mean? Is this a way to define a workbook that will be referred to multiple times? What does the "\" represent?

I get confused on what a string represents and how to define them properly. Thank you again for the assistance in the code. I am impressed and it is extremely helpful for me.