Need help finding a formula that will work

[CreativeRova]

Hi,

I am still looking for an answer to the below issue that I can work in to the actual spreadsheet

The master version has many columns that I have listed below

Master workbook
[TABLE="class: cms_table_cms_table_grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]July[/TD]
[TD]July[/TD]
[TD]July[/TD]
[TD]August[/TD]
[TD]August[/TD]
[TD]August[/TD]
[/TR]
[TR]
[TD]Client[/TD]
[TD]Agency[/TD]
[TD]BDM[/TD]
[TD]Value[/TD]
[TD]Format[/TD]
[TD]NEW[/TD]
[TD]Status[/TD]
[TD]Media[/TD]
[TD]Production[/TD]
[TD]Quantity[/TD]
[TD]Media[/TD]
[TD]Production[/TD]
[TD]Quantity[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]SUM[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]SUM[/TD]
[TD]SUM[/TD]
[TD]SUM[/TD]
[TD]SUM[/TD]
[TD]SUM[/TD]
[TD]SUM[/TD]
[/TR]
[TR]
[TD]Client 1[/TD]
[TD]Blah[/TD]
[TD]Karen[/TD]
[TD]$10,000[/TD]
[TD]Ad[/TD]
[TD]YES[/TD]
[TD]PENDING[/TD]
[TD]$4,000[/TD]
[TD]$2,000[/TD]
[TD]50[/TD]
[TD]$4,000[/TD]
[TD]$0.00[/TD]
[TD]50[/TD]
[/TR]
[TR]
[TD]Client 2[/TD]
[TD]Blah[/TD]
[TD]Kim[/TD]
[TD]$15,000[/TD]
[TD]Ad[/TD]
[TD]NO[/TD]
[TD]Confirmed[/TD]
[TD]$12,000[/TD]
[TD]$2,000[/TD]
[TD]100[/TD]
[TD]$1,000[/TD]
[TD]$0.00[/TD]
[TD]15[/TD]
[/TR]
</tbody>[/TABLE]




The above is updated constantly every day.

The sales persons version only shows their deals and sums. There will be 13 tabs on the bottom a summary tab and 12 months. The below is an example of JULY

Sales Workbook
[TABLE="class: cms_table_cms_table_grid, width: 500"]
<tbody>[TR]
[TD]Karen July[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Budget[/TD]
[TD]$50,000[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Confirmed[/TD]
[TD]E9[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Difference[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]% of Budget[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Lost[/TD]
[TD]L9[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Pending[/TD]
[TD]S9[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Confirmed[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Sum E11:E:2000[/TD]
[TD][/TD]
[TD][/TD]
[TD]Lost[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Sum L11:L2000[/TD]
[TD][/TD]
[TD][/TD]
[TD]Pending[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Sum S11:S2000[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Client[/TD]
[TD]Agency[/TD]
[TD]Value[/TD]
[TD]Format[/TD]
[TD]Monthly Value[/TD]
[TD]Production[/TD]
[TD][/TD]
[TD]Client[/TD]
[TD]Agency[/TD]
[TD]Value[/TD]
[TD]Format[/TD]
[TD]Monthly Value[/TD]
[TD]Production[/TD]
[TD][/TD]
[TD]Client[/TD]
[TD]Agency[/TD]
[TD]Value[/TD]
[TD]Format[/TD]
[TD]Monthly Value[/TD]
[TD]Production[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]



So I need A11 to pull the info from the master workbook. but only the selected info not every line. It also needs to only show in the July tab if there is an amount in July if the Media amount is in August Media then show in the August tab.

Pull the relevant info leaving no blank rows.

This list needs to update automatically from the master sheet, no blank rows so can be printed if needed.

Thanks.