I am looking for a way to import data from multiple worksheet into a single sheet of a new excel file.
More info: All worksheets are stored in the same folder. All worksheets have same column headers but varying number of rows.

Thanks.