Formula to Pull Data from Multiple Worksheets

Attach a sample workbook (not image).

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Ok - Example spreadsheet is shown - the desired info is a mock up as I cannot get the formula correct. I only want information from Sheets 1-3 to show up on Sheet 4 when the Pick Up date is filled in.

I"m more than happy to provide more info - if anyone is willing to throw any ideas out. I'm just stumped!

It would be much easier if the all the data was one one sheet.

With Data in one Sheet (Model1)

in A2

=IFERROR(INDEX('Model 1'!$B$2:$B$1000,SMALL(IF('Model 1'!$E$2:$E$1000<>0,ROW('Model 1'!$B$2:$B$1000)-ROW($B$2)+1,""),ROWS($B$2:B2))),"")

in B2

=IFERROR(INDEX('Model 1'!$A$2:$A$1000,SMALL(IF('Model 1'!$E$2:$E$1000<>0,ROW('Model 1'!$B$2:$B$1000)-ROW($B$2)+1,""),ROWS($B$2:C2))),"")

in C2

=IFERROR(INDEX('Model 1'!$E$2:$E$1000,SMALL(IF('Model 1'!$E$2:$E$1000<>0,ROW('Model 1'!$B$2:$B$1000)-ROW($B$2)+1,""),ROWS($B$2:D2))),"")

Enter ALL above ..

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

I unfortunately cannot put everyone onto one Data sheet - as we have dozens - in one case hundreds - of entries per model and sorting that data when a new entry appears is a bit of a nightmare - we are doing that now and having issues with data entry and being able to see the data correctly. I gave a VERY dumbed down version of our spreadsheet for the example. But thanks for trying!

OK - I apologize in advance for all of the questions XOR LX - Your worksheet example was exactly what I needed, but I cannot get it to work by replacing the Y as you suggested above. I am attaching your worksheet, w/ modification to the formulas as suggested above..I replace it in Arry1, G1 and only replaced in actual Cell A7, you'll see the error. Can you tell me what I'm missing or doing wrong, as it won't read correctly no matter what I do.