Avatar of kingdingathing
Flag for Australia asked on

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

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    |

Open in new window

Microsoft ApplicationsMicrosoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Arno Koster

8/22/2022 - Mon
Arno Koster

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question

What can I say but AWESOME, works perfectly!

Thanks a million!

AWESOME! So clean and simple! :)
Arno Koster

you're welcome !
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck