I have multiple sheets relating to each room in a house, I also have a master sheet showing the overview of the whole house, what id like to do is pull all the data from the room sheets into the master sheet so that I can use filters across the whole house.
I could just copy and paste the data across but id like the data to be dynamic so that if I make a change in the room sheets its reflected in the master sheet.
I know I can reference cells by using
=bedroom!A1 in the cell but how can I do the whole sheet?
Im using Google docs for the spreadsheet as it allows every one in the team access to the data, it seems to be very similar to excel so im sure the awnser would be similar