Many reports from one worksheet

Good day to all.
I have a few problems that I'm trying to solve using macros.
Namely, I have a worksheet called "Report" and it serves as a source of data. From that worksheet, I try to select a specific user (in this case "C") and get another worksheet that will be called "C" and that shows only what that user used (worksheet "C").

In the second case, I want to get from the same data source data related to only a certain article (in this case "A4 80g paper" in the way it is shown in the worksheet "A4 80g paper", and that in cell "A2" is the name of the item that are in the table ("Box 5 reams / 500 sheets UPM Multifunction A4 80g paper").

The third case is similar to the second only in terms of toners.