Display all data from multiple sheets that are between two dates

[Xcelltime]

I have multiple sheets that each have headers named (from A4 to F4) Dates/Type of Trans/Descr/Deposits/Withdrawals/Balance with data in each cell below. I have made a named range called "Accts" that I have referenced all the sheets. I have a sheet called "Report" that I would like to list all the deposits from all sheets between beginning and ending dates (H1 and C1 respectively).

I have been trying to find a formula to list all the data that meet my criteria. I have successfully found a formula that will find all the transactions on one sheet named "Account", but can not make it work with multiple sheets. Here is the formula if it helps. This gives the date field from each and I know to copy/modify to get the other columns that I want.

{=IF(ROWS(E$5:E5)>$G$1,"",INDEX('Account'!A$5:A$103,SMALL(IF('Account'!$A$5:$A$103>='Report'!$H$1,IF('Account'!$A$5:$A$103<='Report'!$C$1,IF('Account'!$D$5:$D$103<>"",IF('Account'!$B$5:$B$103="DEP",ROW('Account'!$A$5:$A$103)-ROW('Account'!$A$5)+1)))),ROWS('Report'!E$5:E5))))}

This formula references G1 which has the formula:

=COUNTIFS('Account'!A5:A103,">="&'Report'!H1,'Account'!A5:A103,"<="&'Report'!C1,'Account'!D5:D103,"<>"&"",'Account'!B5:B103,"="&"DEP")

If anyone can help me out, I would appreciate it. Please let me know if you need any other info.

Thanks in advance!