Forum Discussion

Copper Contributor

Jan 07, 2020

How do I auto-populate information from one tab to another in sheets?

I have an excel sheet with several tabs. The first tab is the Master tab used to track all tabs. I would like all new tabs to auto-populate information into columns on the master tab. For example, I ...

excel

Formulas and Functions

DH2

Copper Contributor

Feb 05, 2026

I realize that this is an old post.

I have a master sheet that I want to auto populate from the same cells off 100plus sheets. All the sheets are identical and have a certain few cells that I need to view on the master.

I have tried to drag and fill the formulas, but it always increases the reference number instead of increasing the sheet number

Could you please give me advice?

SnowMan55

Bronze Contributor

Feb 06, 2026

Advice #1: Avoid replying to old posts with lots of replies. Create a new post, and if appropriate, refer back to the old post by including a link.

Advice #2: Identify which Excel product you are using (e.g., Excel 365, Excel 2019) on which platform (Windows, Mac, the web...).

See this workbook for information related to your issue: 2026-02-06 DH 3-D references in formulas.xlsx