Fetch rows provided there is a difference in one of the cells

[sofas]

Hello. I have on file sheets 1 and 2 sheet 1 column B includes customer names that are sometimes repeated.and from column c to t customer data. I want when writing his name in Sheet2 cell m4 All rows related to the same name are brought to Sheet2 starting from cell b6 provided there is a difference in one of the cells and in case of the same values are ignored

 

[DanteAmor]

Im glad to help you. Thanks for your kind comments.