If you work with multiple spreadsheets in Excel, and need to transfer data from one to the other, or summarize in one workbook data from others, you can set up the summary worksheet to automatically pull the data from other worksheets and workbooks. Once you have the links in place, a change in any of the data worksheets will be automatically updated.
Want to know how? Join us for our next class. Our classes are hands-on, and cover this topic and much more. For what's covered, check out the Excel Topics page of our website: