Copy worksheets to another workbook

Hello,

I am trying to copy worksheets from 5 different spreadsheets. The worksheets that need to be copied should contain the word "IFIP" within the worksheet tab name. After the macro finds the tabs matching IFIP, then i want to copy these workbooks to another spreadsheet that i have created.

I have tried to do a For Each function but no joy.

Can you please help me out. I would greatly appreciate your quick response since this needs to be done by today.

Best regards,
Dimitrios