Copy paste data after filter

Hi
I need a help to create a macro. In the attached sheet I have a tab named Raw data. One of the fields in that sheet is PID column “B”. I have different tab for each PID.
Now…

1. I have to filter each PID from column B, copy the data for all the column and paste it to respective tab. For example I have to filter “AA0967” copy the data and paste it in “AA0967” sheet in the respective area.
2. I have to do it for all the PID

I’ve given a sample. No of data is huge , so if it is possible to write a macro code it will help me a lot.

I have tried but having some issue. Each time I’m filtering the PID, cell ref getting changed.

Any help will be much appreciated ………..