troubleshooting Question

Copy a cell from one sheet to another based on the sheet name equaling a cell

Avatar of kingdingathing
kingdingathingFlag for Australia asked on
Microsoft OfficeMicrosoft ExcelMicrosoft Applications
4 Comments1 Solution374 ViewsLast Modified:
Hi eveyone,

Probably an easy one for you.

I have a spreadsheet with 113 worksheets. One of those worksheets (being sheet 1) is a sheet that is to collate data from one cell in every other worksheet. Every sheet (except sheet 1) is named very differently, specificly people names.

What I'm after is... in sheet 1, I would like to copy the contents of one cell in one of the other 112 sheets to sheet 1. BUT the formula must be the same in evey cell in sheet 1!

In sheet 1 I have every persons name listed, from A5:A115. So I want to compare the name in column A with the sheet name and if it = TRUE then copy the contents of a specific cell.

So Im hoping one of you gurus can help me with some formula magic!!

Hope that makes sense...


Last Name | First Name | Total
Smith     | John       | $250.00 \
Anderson  | Jane       | $75.00  /  Formulas must be the same

--Smith, John-- '(aka Sheet2)
Total     |
$250.00   |

--Anderson, Jane-- '(aka sheet3)
Total     |
$75.00    |
Arno Koster

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros