Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Here is what I want to do. Sheet one on a workbook is a "master list of all. Sheets 2 thru 5 are location breakdowns of the master list, with column B being the location. I want to be able to change the location on Sheet one and have it populate/depopulate the proper location sheet 2 thru 5

share|improve this question

Try using the INDIRECT function. See here for a tutorial.

share|improve this answer

You can reference a cell on another worksheet using the following format Sheetname!Cell identifier. For example:


You can directly enter this on cells on the other sheets. Or type = and then select the other sheet and then select the cell you want and then hit the Enter key the referenced cell will be inserted for you.

share|improve this answer

Consider to use so called 3D-formula: assuming you need to "populate" cell A1 from sheets 2-5 use this formula: =SUM(Sheet2:Sheet5!A1)

Read more: 3d formulas in Excel 2010

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.