I have one spreadsheet that is for global use in which I would like to incorporate one cell of data from various other spreadsheets to refresh anytime there is a change to the source. So for example:
I have spreadsheets named "Client 1", "Client 2", "Client 3" and so on. I need cell G24 from each of these sheets to be automatically included in a spreadsheet call "Global Client List" and to automatically refresh whenever there is a change to Client1, Client2, etc..
I can import data from another spreadsheet under the "Data" tab easily enough, however, it imports the entire spreadsheet and will not let me choose just the one cell I need from each.
Can anyone help with this please?