I'm fairly new to Google Spreadsheets and completely useless when it comes to functions and formulas.
Is there a way to take info from multiple sheets within a workbook and compile them into a master sheet within that same workbook?
If so, is there then a way to have any changes on the original sheet then be reflected in the master sheet?