Consolidating data from various worksheets into a consolidated worksheet

Hi All,
I am new to VBA code and was hoping you could potentially help. I have seen a few threads on here regarding consolidating data onto one worksheet from various tabs but none quite fit the bill.
Essentially I am looking to consolidate data from various tabs. The steps would be as follows:
• Take data from column A to V from various tabs and consolidate on one worksheet – the column structure will be static
• Name new consolidated tab as data
• Ignore rows that do not have data in column A, B OR C. So even if there is no data in just one column, it does not consolidate
• Ignore certain worksheets i.e. within the workbook I will have sheets that are irrelevant to consolidation – this may require renaming worksheets to make it easier, which I can do. Potentially with a full stop suffix?
• The headings on the consolidated tab will need to match the headings on the worksheets it is pulling from
• Loop so it can be performed and it will delete the old consolidated data tab and replace with a new one, with updated data
Some challenges are the number of rows and the ordering of the codes in column A – C can alter frequently (i.e. move up and down on the row numbers, so they not static on each sheet but columns are) – I don’t know if this poses the biggest challenge. The rows may vary in the number - some sheets may have 20, some may have 200.
Help would be hugely appreciated.
Thank you in advance

Hi

You can try using the Data Consolidating where you can add all ranges and select the consolidate function.

See the menu data for that.

Hi All,

Thanks for the responses. PCI - that is great - that was what I was looking for.