I have a huge file contains many sheets, each of them with an ID and each sheets contain detailed of the spend for telephone.

I would like to understand the spend of particular typology, say SMS and therefore need to copy the data of the row where I find the cell with value SMS (basicly if I can find cell A5 with value SMS, I'd like to copy the cell B5 and this sheetname puting into 2 columns in a new sheet called summary

i am a newbie to macro and dont even know if these would be feasibile, the file is not big, just text. Please help me..Many thanks!!!!