Search using formula

I have around 10 sheets in excel say sheet name as 1 , 2 , 3 .....

I wanted to search a word in specific sheet and get the Number from the next cell using formula

Say for example - I am working in Sheet 5 , i wanted to search closing balance from sheet 4 as how that as opening balance using formula .

and when i use sheet 6 it should automatically take value from sheet 5

Similarly when i create a new sheet say 11 it should pick value from sheet 10

Thanks in Advance
Mahender Lalwani