Capturing headers and data from multiple tables

[meranamjkr]

Hello
Trying to capture unique headers and data under the specific columns from multiple tables into one. Example SS is attached. What is the tables were on separate Excel SS?
Vehicle ID may be the one common header and column which can be used to get all other data from all other sheets into one row. I would like to capture this data for all vehicles based on Vehicle ID into one row, therefore having a unique header and column from all tables for that particular Vehicle ID
Many thanks in advance to anyone who will help.

[azumi]

Not sure about the desired result, what data do you want to capture? Merged 3 tables to one?

[meranamjkr]

Not sure about the desired result, what data do you want to capture? Merged 3 tables to one?

Yes please
Looking for unique value headers and their respective row data
E.g. If Vehicle ID is in multiple tables then only use once in new/result table

Thanks

[azumi]

Something like this? Pls check the file


Regards

[meranamjkr]

Exactly like this

Thank you so much for this

God bless you!

[meranamjkr]

Thank you so much