Copy cells from a TABLE to another sheet as a value dependant on multiple cell values

Hello Folks,

I have a dashboard that now needs to list sales opportunity names and details for the weekly reports.
This data comes from TABLE within the workbook and I am having trouble copying this data to the report sheet.

Attached is workbook with a descriptions of the work needing to be done.

The table name is Table_Company_Sales_History___Total

Caveats are that the list size will not be a constant, as all sales reps see a different number of contacts each week.
I had attempted to sort the table and copy the results but the time taken is restrictive for the number of sales reps to report on each week.
using this partial code

Please Login or Register  to view this content.

Thanks in advance for any assistance

bumped as still needing some assistance with this one