hi all,

I want to take the data account number of the sheets next to it in accordance with their respective names using a specific formula .
I have more than 50 sheets , is there a formula to directly copy the account ???.

Please kindly help, thank you in advance

formula from another sheets.xlsx
Regard

dolphino