Using User form to load workbook, extract and combine desired data into new workbook or worksheet

[SimpleUser]

Hi. I have this excel workbook xlsx with the 1st worksheet named as "Email Status" with data from column A to S as shown below.

I've previously manually extract the VM data by filtering and copying onto a new sheet for each ReferenceCode then using function

=CHAR(34)&"Name"&CHAR(34)&" IN ("&CHAR(34)&TEXTJOIN(CHAR(34)&","&CHAR(34),TRUE,Extract!C2:C14)&CHAR(34)&")"

to get results for those with "Exception" status. It's a bit troublesome to do it daily using this method.


Instead I'm thinking of using a user form. The idea is to load the excel workbook data and then by clicking the button it should export the desired data into a new workbook or worksheet.

I need help on the user form to load the workbook, extract and combine the VM data with only the status "Exception" according to each similar "ReferenceCode" into another workbook or worksheet to look like the following results as shown.

Is there any way that this can be done??

 

[mumps]

You are very welcome.