Excel help - creating a macro or Vlook up to bring data together

Hello
We have 4 datasheets in an Excel workbook. We keep contact data (name, company & email address) on there, each sheet has the contacts split into groups that they attend across the columns. There are probably c800 contacts across the sheets.

Periodically I am looking search and bring together on a separate sheet all the contacts with a specific company email domain + the group they are each in - as I want to show that company which of their staff are involved in our groups. I would do this at a point in time. We are currently do this manually.

So I am looking to have something set up on an extra sheet where I can specify which email domain I am looking for this time and then to 'run' it, and it will pick up the relevant contacts on each of the sheets and also the title of the group they are in. I am thinking perhaps a macro would work?

See my fake data sheet. I am not looking to change the format/layout of the worksheets if possible, as we are all used to working with them as they are.

Can you please quote for this work, I just put in a figure. I will share the actual spreadsheet with the freelancer once I have accepted your proposal.

Many thanks
Abby