Combine Two Different Workbook to the New One

[Rahulwork]

Hello Everyone,

Hope all are doing great. Bit new to VBA so I need your help to create code for below situation.

I have an excel where at

F4 - i have a folder path which contains excel files

In F5 i have one excel file name contain in F4 path

- Sample No Match 20200728.xlsx

In F6, i have one more excel file name contain in f4 path

- Sample Yes Match 20200728.xlsx

Now i want my macro to -

1. Go to F4 Path
2. Create New Workbook by name of "Consolidated Sample Today"
3. Copy and paste the data of file in F5 into new workbook
4. Copy and paste the data of file.in F6 after the data of F5 ( Below of that as it has same header)
5. Save and close all workbook in F4 path

Please let me.know.if you need any further information on the same. Your response will.be appreciated

Note - I have to pick file.name from excel only