Save selected worksheet into single separate file.

Dear All,

Kindly assist.

Please find the file attached.
In the file, there many worksheets.

In few worksheets, in cell A1, "AIB" is written.

Is there any way in which all the worksheets, in which there is "AIB" , be saved in separate file ?

In my work enviroment, there are approx 100 worksheets from which I have to save approx. 30 worksheets seperately. Its time consuming.

Please help me.