Consolidated Monthly Report

Hi Everyone,

Please help me with this issue.
I Have data which is to be updated everyday in SHEET 1, I need the same to be available in SHEET 2 as a consolidated Monthly report.
For ex, The Job Card which is been done in sheet 1 everyday as there are around 50 Jobs per day, but all the details should be available as such in the same columns of sheet 2 based on the current update.

I suppose you're not just looking for a formula like =IF(Sheet1!A1="";"";Sheet1!A1) in sheet 2 A1?

Could you upload an example file with some manually generated desired results?

I attached the file, where in I am entering the details in Daily Sheet the same as to come in Monthly sheet as content.

Do I understand correctly that you want the data from sheet one copied to sheet 2 every day, and then delete the data from sheet 1?

You'd need a macro for that. I only know some VBA semantics about copying and pasting, but not enough to write the macro for you. So here's a call to the VBA-folks: please help!