Best way to combine two tables into one.

[Minot1988]

Hello,

I'm new to these forums so please bear with me.

I have a project tracking workbook that contains 4 worksheets.

Worksheet 3 & 4 contain the tracking data for 2 different types of projects. One is considered the parent (I've denoted by a unique field such as 00001A) and the other sheet contains project tracking for the children projects (00001B, 00001C)

Worksheet 1 & 2 are just view & print sheets that pull the data from these two sources and create a couple additional columns based off of that data.


What I want to do

I want to take all the data in worksheet 2 & 3 (the source sheets) and combine them into a master sheet. I should be able to sort the master sheet in a couple different ways. I am not trying to aggregate the data.

I'm running Office Standard 2013

Pleas let me know what you think.

(I've attached an example of the sheet I am working with)