Free. Exclusive. Just for you.
Four unique services that make learning easier, faster, and smarter - only on our website.

This example demonstrates how the INDIRECT function dynamically pulls values from different sheets based on the sheet name listed in column B.

Excel spreadsheet showing the INDIRECT formula to create dynamic links to different sheet names.

Excel spreadsheet showing the INDIRECT formula to create dynamic links to different sheet names.

PNG 700×400 35.9 KB Free · Personal Use
Quality Assured by Worksheets Library Team
Reviewed for educational accuracy and age-appropriateness
ID: #347439
Print Download

How to use

Click Print to open a print-ready version directly in your browser, or use Download to save the file to your device. The ⭐ Answer button generates an AI answer key instantly - useful for teachers who need a quick reference. Need a different version? Our AI Worksheet Generator lets you create a custom worksheet on any topic in seconds.

(view all excel reference worksheet)

Excel formula: Dynamic workbook reference - Excelchat
Get sheet name only - Excel formula | Exceljet
How to increment worksheet reference automatically in Excel?
Excel Reference to Another Sheet | How to Refer from Another Sheet?
microsoft excel - How to reference worksheet with space in name ...
microsoft excel - Reference to a Table from another worksheet ...
How to reference formulas in same Excel worksheet - FM
Return Sheet Name into a Cell - Excel Formula
Use Excel INDIRECT to dynamically refer to worksheets - Excel ...
Microsoft Excel Worksheet Function Reference (Microsoft Reference S.)