Consolidate Multiple Excel Files into one -

I have two workflows which i created. The both output are saved in my local system (2 separate folders). Each folder comprises of 300 files.

My challenge is that I want to append one file in folder 1 with the another file in folder 2.

Note: Both files belongs to the same UserID. The difference is that they have different information. I also want to use loops to check in folder 1 and folder 2. If the both folder has the same userID. Then it should consolidate both files into one excel as sheet 1 and sheet 2.

Please i require an urgent help in order to save my job :cry: