Forum Discussion
How do I auto-populate information from one tab to another in sheets?
- Are you willing to manually enter the name of each new tab into a cell on the "Master" sheet?
- Is all the information on each individual sheet organized in exactly the same way? Are they all laid out identically?
- Finally, could you upload a sample of the actual master and backup sheets?
If the answers to #1 and #2 are both "Yes," then it should be fairly easy to write a formula or two that would retrieve the information from each new sheet and populate the master sheet with the data. But an actual example of your workbook (devoid of any confidential or personal information) would be most helpful.
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?
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
