using dictionary to brings data based on word in column

[abdelfattah]

Hi,
I search for the internet to brings data across sheets to MASTER sheet based on word "CCV" in column B across sheets.
and I got code and adapted based on my requirements ,but the only thing happens just copy from last sheet and ignores the others. when try run the code every time should delete data in MASTER sheet before brings data. I would do it by dictionary, not else way.

so I put expected result in MASTER sheet
thanks