Getting Column Details from tabs

Hi,
I am making a personal budget sheet in which I have a dashboard tab on which I am getting Nearest due date from the individual monthly tabs in the worksheet. I have managed to get the date but I want to show the next two columns for this nearest due date on dashboard tab as well. Is it possible to do that?

Nearest Due Date What Amount
03-January-2018


Thanks in Advance.

I used a "helper" cell to get tab name

in H16

=TEXT(H15,"mmm" & " " & "yy")

in I15

=INDEX(INDIRECT("'" &$H$16 &"'!a3:A20"),MATCH($H$15,INDIRECT("'" &$H$16 &"'!B3:B20"),0))

in J15 (unmerged)

=INDEX(INDIRECT("'" &$H$16 &"'!C3:C20"),MATCH($H$15,INDIRECT("'" &$H$16 &"'!B3:B20"),0))


NOTES:

1) I had problem with INDIRECT with single quote in you tab name so i replace it with blank e.g Jan 18 (someone will no doubt get the correct syntax)

2) You can replace H16 in the I15/J15 formula with formula in H16

Thanks John.. This works for me. The only thing is when I changed the computer date to test it for future dates, the formula for finding the nearest date always returned with a false value. I am not sure why it happened but it works perfectly fine when I change the date to current timings.

Thanks
Vyom

Quite simple: there isn't a tab named "Dec 17".

I assumed any due date would be in the month in H15: I did not expect a due date of December in January!.

If this not the case, then we need a different solution

Thanks for the reply. Yes some of the due dates can be in different months as well. Like the one coming after 28 days. I tried to test changing the date of the computer to July 18, getting the same error. I kept the Jan due date in Feb month, got the same error again.

In H15

=IF(MIN('Jan 18:Dec 18'!B3:B20) < TODAY(),FALSE,MIN('Jan 18:Dec 18'!B3:B20))

in H16

=INDEX(SheetList,MATCH(1,--(COUNTIF(INDIRECT("'"&SheetList&"'!$B$1:$B$200"),$H$15) > 0),0))

...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.

In O1:O13 create named range "Sheetlist" (list of all your sheet names)

Thanks a lot John.. This is exactly what I wanted. Thanks a lot.