Ok guys I am hoping what I want to do is possible and that you can point me in the right direction...
When I paste into column a if a certain name comes up for examples 7 daze I would like it to auto copy that row to another page titled 7 daze and so on and do that with all of my brands
I'd be tempted to set something up with Pivot Tables
If you specifically want the data on each page then you could click the option highlight in the screenshot attached
March 12, 2020
July 16, 2019
May 17, 2019