Macro to consolidate individual sheets into single sheet

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

Hi,

Thank you for replying.

I can't find a way of uploading a copy of the file I would like to consolidate (multiple copies of the same template).

Basically, I will have multiple copies of a template from various sources. It will contain 23 columns of data.

What I am trying to do is to consolidate all my copies into a single sheet (I've managed to bring them all together but in separate tabs).

Each of the templates will have a different number of rows so the macro should copy all rows with data (note that some fields may be blank in the workbook, but the First Column will always hold a value (Col. A) ).

I appreciate your assistance.

Regards,
CA