How to combine a code and a macro

Hello folks,
I have a code and recorded macro. Could you please help me to merge the codes into one to be able to work with different range of data set?

Code #1: Combine files in a folder into a workbook

Please Login or Register  to view this content.

Code #2: A recorded macro to convert 5 columns worksheet to 3 columns (Combining YMD columns into "Date" column)
The problem here is, I have to run the code for each worksheet separately, and I don't know how to do it for a workbook since the data range is not fixed.
I couldn't use the "Range("A" & Rows.Count).End(xlUp).Row" function correctly.

Please Login or Register  to view this content.

Try this,
I used a sheet names "Start". When you run the code, the code will delete all the sheets except sheets("Start")

Please Login or Register  to view this content.

Enter the date in Sheets("Starts") range("A2") and run the code.

Please Login or Register  to view this content.