I have two Google Sheets named Sheet_1 and Sheet_2. I want to link both these Google Sheets and fetch the cells numerical data from Sheet_2 to a specific cell location in Sheet_1.
For example Sheet_2 has a cell C9 with numeric data 20000 which I want to store automatically to cell B5 in Sheet_1 with the functionality that whenever I make any change in C9 Sheet_2, then it automatically updated in B5 Sheet_1.
I tried to search how to implement it but unable to do the same. Please provide me a solution how to do this.