Collating MULTIPLE files

into one Excel File


Collating Multiple Sheets into ONE file

This process is fairly simple, provided you know how the code works., I am publishing code here, which you can copy and paste into Excel., after following the given procedure to do so.
Example: If each sheet from different files are to be imported to the current workbook, then following procedure / Code will he helpful.
Where do we USE: If there is a team of 10 people, maintaining excel files the same type of data in a single workbook, in their work.

Procedure

  • Press Alt + F11
  • Copy Code from here and paste into Code Window
  • Place a Command Button on WorkSheet
  • Assign this code to the command button
  • Compile this code by pressing Alt + D, L
Work done...

User Activity

  • Click on the Command Button
  • a File Open Dialog box is displayed
  • Select the files that are to be added to the current workbook
  • Click OK on the FileOpen Dialog box
  • Compile this code by pressing Alt + D, L
all the selected files are added to the current workbook

Expected OutCome..

expected output

Sample Code:

expected output

expected output

The following images are for your reference:

Images for reference only..

expected output

Sample Sheet 01 (Data source: Internet - generic Data)
expected output

Sample Sheet 01 (Data source: Internet - generic Data)
expected output

Consoliated Data Sheet (Data source: Internet - generic Data)
expected output

VBA doesn't die as long as Excel lives.. ,
don't believe, false market claims....
✅✅, so practice and make your life easier