poiting a certain number to identify how many time it is repeated

[spolonova]

Please I really need to handle a sheet with data but I am not aware how
What I need is to point a certain digit for exampla"22" ,to find it through all data in columns in different sheets and as a result if "22" is found to copy and paste the number situated in the next cell to the number I have initially pointed as main (in my case for example"22" )I tried to present with a certain example below and as a result I expect only "33" and "1 ",because they refer to "22" in the pointed columns in all sheets

I tried with VLKOOP, but didn't succeed to suit to my needs
A ;B
1 ;27
22 ;33
22 ;1
4 ;22
5 ;0

Really thank you and sorry for losing your time ,I suppose the question is for dummies

[grizzly6969]

here is a sample page of a formula that will do that