Combining Tabs into one

Hello Everyone,


I have 8 different excel tab that each of them containing 2 NL fuctions.

I would like to get that 8 tabs information into one tab. 

I have tried using  " ='sheet1'!C4 "  etc ,but this did not really worked.


Is there any way to do this please? 


Thank you. 




Please sign in to leave a comment.