Hello,
I have a set of identical excel worksheets that are completed by various team members. All these sheets have the same number of columns but varying number of rows.
I would like to create a macro that will consolidate all the data from those individual sheets into a single sheet.
I have found various online tutorials but they all end up consolidating the individual sheets into a single workbook but as separate worksheets within the same workbook (i.e. they are not consolidated into a single worksheet).
I'd appreciate any help
Thanks
Bookmarks