Working reference sheet from multiple sheets/ranges

[glorg]

Hey everyone,
Not sure if this is simple or complex, all I know is it's beyond me...
I'm trying to get a run sheet going from multiple sheets in a book. They are formatted thusly:

<style><!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";}@page {margin:1.0in .75in 1.0in .75in; mso-header-margin:.5in; mso-footer-margin:.5in;}td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignoreadding; color:black; font-size:12.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked visible; white-space:nowrap; mso-rotate:0;}.xl63 {mso-number-format:"Short Date";}.xl64 {mso-number-format:"Short Date"; border:.5pt solid windowtext;}.xl65 {border:.5pt solid windowtext;}--></style>[TABLE="width: 455"]
<!--StartFragment--> <colgroup><col width="65" style="width:65pt"> <col width="65" style="width:65pt"> <col width="65" style="width:65pt"> <col width="65" span="4" style="width:65pt"> </colgroup><tbody>[TR]
[TD="class: xl65, width: 65"]Serial No.[/TD]
[TD="class: xl65, width: 65"]First Name[/TD]
[TD="class: xl64, width: 65"]Last Name[/TD]
[TD="class: xl65, width: 65"]Date #1[/TD]
[TD="class: xl65, width: 65"]Date #2[/TD]
[TD="class: xl65, width: 65"]Date #3[/TD]
[TD="class: xl65, width: 65"]Date #4[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]132456[/TD]
[TD="class: xl64"]Phil[/TD]
[TD="class: xl64"]McCracken[/TD]
[TD="class: xl64, align: right"]1/08/18[/TD]
[TD="class: xl64, align: right"]2/08/18[/TD]
[TD="class: xl64, align: right"]3/08/18[/TD]
[TD="class: xl64, align: right"]4/08/18[/TD]
[/TR]
<!--EndFragment--></tbody>[/TABLE]

What I'm trying to get (unsuccessfully so far) is for dates in a range, from all sheets, to display on a "master" sheet e.g. everything that is 0-60 days from today will appear.
I've tried variations on lookups and 'if' functions to no avail.
Any help greatly appreciated