Copy specific columns from all excel files saved in selected folder

[KKR1975]

Hi

please help to create vba code for the below

I want to copy specific columns from all the excel files saved in one folder
In this example I have saved 3 sample workbooks
All workbook starting from row 4
Column A and B is fixed one
Column C Amount is not fixed one, hence its required thorug message input box. (if user type C, then all excel files C column to be copied, if its K then all excel files column K to be copied)

Step1: In Output File row B5 and C5 is fixed.
Step2: Remaining column like D5 to F5(as per sample) header to be updated based on excel file names.
Step3: Row no b6 is from to be copied from excel files saved in selected folder
In Sample I saved the files on C:\sample workbook