Copy paste data one to multiple sheet based on cell value to sheet name

pls help code i am new to macro and forum

thank in advance

Here's another way of solution of the problem you
in H1 in each cell I wrote the formula =MID(CELL("filename";A1);FIND("]";CELL("filename";A1))+1;256)
this formula gives you the name of the active sheet
then I used autofilter in each sheet
and this result for you frend

Thank you for response

Thankyou sir