vlookup over multiple pages and return multi values

Hi good people!,

I am sitting with a workbook which contains about 15 sheets. Only one column (the same column for all sheets), contains specific text. I am looking for a way to extract those text values with the values in their respective rows, 4 columns to the right. so, what I am thinking is that if I write the text in a blank sheet, say A1, a long list of all the instances of the text in all the sheets, must follow with their respective values, which are 4 columns to the right. On the blank sheet where I input the text, the output may be in adjacent columns. They do not have to be 3 columns apart.

I trust my explanation of what I am looking for is clear...please help me with this. all help will be greatly appreciated. Thank you all kindly.

Hi Special-K,

I have obviously not explained properly, my apologies. I have learnt in the meantime that I could achieve what I needed to do with Kutools. I have managed, thank you very much for your time..