VBA to copy entire columns from one spreadsheet and insert the copied columns into multiple spreadsheets within many subfolders in a directory

[ParrBee]

I am new to macros/VBAs so I'm looking for help in writing this code.

I have a spreadsheet that is used as a data source (SourceFile), which contains data in Columns F, H, and I. I would like to copy the entire column of all three columns and INSERT them into multiple workbooks that are saved within different subfolders within a main directory. Ideally, I would have a code that can look at all subfolders within a directory, find each workbook and insert the copied Columns F, H, and I from my SourceFile.

The copied columns from the SourceFile (Columns F, H, I) need to be inserted in the same location in the destination workbooks (Columns F, H, I) --> example: data from Column F from the SourceFile needs to be inserted into Column F in the destination workbook. Because the destination workbooks already contain data, I cannot simply Copy & Paste. Rather, I need to "Insert-shift" columns first so I do not overwrite data contained in the destination workbook when inserting the copied columns from the SourceFile.

The destination workbooks contain different file extension types such as, xlsx, xls and csv. I want to be able to run the macro and insert the copied columns into all workbook extension types.

Is there a way to write a macro that can copy columns from the SourceFile, insert-shift columns in the destination file and then paste the copied columns from the SourceFile to the specific location inside the destination workbooks?

Thanks in advance!