Compile spreadsheets into one

I need a few different things from the spreadsheets compiled into one main spreadsheet. I need it to be comprehensive. The tracking spreadsheet needs to contain all of the fields from the justification and monitoring tab and the recruitment activity tab on 45786-Na-PCM-1-Dec spreadsheet. The spreadsheet (Marketplace Recruitment File) was the attempt at building an ultimate spreadsheet we are looking for. This spreadsheet is for the purpose of communicating activities back to the state. We want to add drop downs for status colums (ccrf submitted, CCRF completed, etc.) We would also like it to be a little colorful if possible. Network recruitment project spreadsheet is what I came up with so far, but I need all information from the other two spreadsheets compiled. Does that make sense?