VBA to split 2 column B&D values rows depends upon values from sheet column A&B

Dear exeprt

I have set of data which need to filter column B&D, split particular some values meet up with *asterisk match

where as sheet (filtervalues) column A if meets with column B then split to sheet Split_Clauses

where as sheet (filtervalues) column B if meets with column D then split to sheet Split_Clauses

some time string not look like exact match for e.g in filtervalues=MICROSYS In master sheet =MICROSY like this need to split those value too