Sorting Dynamic Data into different worksheets

Welcome to the Forum.

Luckily Excel is full of potential solutions for you

You can use pivot tables and a filter on each to populate the data on each sheet, and you could even use PIVOTCHARTS as well (assuming the format to how you need to view the data)
You could use VBA to mechanically move the data form the SOURCE to the two DESTINATION worksheets.

You can manually filter on the data and copy and paste over the old data each time.

You can use POWERQuery (a free microsoft excel addin by microsoft) to do the work for you, which would automatically move the data into the two tables when you hit refresh.

Glad I could help. I do think pivot tables are a powerhouse of Excel that people don't utilize enough. One of the main reasons is probably because they are not as free form as a bunch of formulas in a Summary sheet, but then you can always aggregate the data in the background with a pivot then use simple vlookups off the pivot table to get the exact look or layout you are looking for.

Also you can use a named range to have a dynamic range to automatically grow with the data, so the pivot table always has ALL the data.
http://www.excel-easy.com/examples/d...med-range.html