Copy last 100 data points from table 1 to another worksheet based on criteria w VBA

Sorry I cannot get super specific with the worksheet, there is some confidential information in it, but essentially I have to keep a record of data points that are tied to different categories. I have to report on them weekly by category with the last 100 data points in each. I would like to ease the process of copying and pasting the last 100 points into the calculation sheet, or using pivot tables.


For the attached sample spreadsheet, how would i go about finding the most recent (based on date) 4 occurrences of the TL category, and copy the needed columns into the sheet 2 table?

Sorry just noticed DMC on sheet2 is ppm

E19 =IF(COUNTIF($A$19:$A19,$A19)<=4,COUNTIF($A$19:$A19,A19),"") and drag up.


After that a pivot table.

See the attached file.