How do I merge all tables in one master table?

Originally Posted by JBeaucaire

Attach a sample workbook. Make sure there is just enough data to demonstrate your need, maybe just a few of these source sheets and then main Master sheet mocked up manually to show your desired result from those few sample sheets.

The workbook is devoid any sample data, and mocked up desired results from that sample data.