Search and return data = please help me brothers

I have 3 sheets file.

1st sheet about purchases
2nd sheet about sales
3rd sheet about day book

i will enter purchase bills by datewise in purchases sheet and enter sale bills by datewise in sales

now i want result in day book sheet

if i input date in day book sheet, it should return all the purchase and sales transactions one by one as output.

Please find the photo and file attachments.

thank you very much in advance