# Have a file with multiple tabs need to pull data from exactly the same rows and columns just different sheets

#### LotusLord

##### New Member
Good evening all.

I am not an expert by any stretch but I have been asked to help with what seems like a large spreadsheet to me. In this file there are several sheets that I need to pull the numbers from and put into 3 master sheets. So for example I'm using the formula =IF(Q6='Escobedo 1'!\$A6,'Escobedo 1'!\$B6,0)

The cell below that is =IF(Q6='Escobedo 2'!\$A6,'Escobedo 2'!\$B6,0), and so on down the line for at least 10 more sheets. I'm looking to be able to minimize the manual changing of values in each of these cells, and auto fill is not working for me as I would like. If I drag down All of the cell references are incremented. Does any one have any ideas how to proceed?

### Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

#### Simon4s

##### Board Regular
Are those the actual formulas? I am assuming B6 will change depending on if Escobedo 2, 3, 4,5?

SO you have ten sheets and ten rows:
=IF(Q6='Escobedo 1'!\$A6,'Escobedo 1'!\$B6,0)
=IF(Q6='Escobedo 2'!\$A6,'Escobedo 2'!\$B6,0)
=IF(Q6='Escobedo 3'!\$A6,'Escobedo 3'!\$B6,0)
=IF(Q6='Escobedo 4'!\$A6,'Escobedo 4'!\$B6,0)
=IF(Q6='Escobedo 5'!\$A6,'Escobedo 5'!\$B6,0)
=IF(Q6='Escobedo 6'!\$A6,'Escobedo 6'!\$B6,0)
...
And u want to keep writing these formulas for all the data in each sheet?

I think it would be better to make a drop down list with "Escobedo 1", "Escobedo 2".... all the way to 10 in "A1". in A2 you type =ifs(A1=Escobedo,'Escobedo 1'!A1[A1=escobedo 2..... all the way to 10

Then you apply to all cells in the sheet[/COLOR]

Replies
0
Views
865
Replies
10
Views
266
Replies
1
Views
145
Replies
1
Views
185
Replies
4
Views
215

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,163,712
Messages
5,833,267
Members
430,200
Latest member

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back