Copy cell based on lookup and match of another.

[Dr_Wes]

I have a document with 3 fee schedules in different tabs. All fees schedules have some similar codes with related fees but some fee schedules don't have a specific code. I would like to combine it into 1 Tab, either a new tab with all the fees or add the other fees to an existing tab so I can compare fees. I attached an example of what I have. 

[#2]

@Dr_Wes If you can create one (structured) table with an extra column indicating the Fee Category (1,2 or 3), a Pivot Table could easily create the combined report you desire. You'll find a working example in the attached workbook.