Consolidate 4 worksheets into 1

[JakeAy]

Hi guys, before you say that this has been done a million times, what I want to do seems to be different enough to warrant a new thread.

I have a workbook with 12 worksheets. 4 of the worksheets have data I'd like to consolidate into 1. Those 4 worksheets have identical column names. They also have rows of data that I don't need at the top of the worksheet (admin stuff like who created the file, etc). Those 4 worksheets will have a varying number of rows of data in them as the source worksheets are modified.

So the question is, how do I combine those 4 worksheets into another worksheet so I have a seamless list? I've already tried analysing and modifying the VBA code shown in another post, but it's just out of my grasp.

Any advice? Example file attached (source worksheets have a "PCB" suffix).