Excel Merge Sheets to Master

This article draws on the post from the site which is dedicated to merging worksheets in a workbook into a single master sheet Consolidate Sheets. This technique can be significantly simplified with a VBA macro. I have posted this type of reply on forums dozens of times. Howeve this reply differs just slightly. The following will consolidate data so the data tables appear side by side in the consolidaiton tab. So if Sheet 1 appears: