Macros for Receipt Log

Dear Members

I' tried to create a macro but was unsuccesful, have attached the sheet for your reference

Required

1. Sheet "Receipt" for primary data entry which after clicking the button update will push the data in Seet "Log"
2. Sheet 'Log" will contain all the data entered in Sheet "Receipt", every entry eneter will be secquentialy reflect as per receipt no,
3. note some receipt might be of one invoice and some upto 40 invoces so the if there are more than one invoice it will reflect in the next row of Column 'L'
4. after finishing the update need one more button on Receipt Sheet for refreshing the sheet so detail of next receipts are entered

can anyone help, I'll be thankful

Regards

Asif

So if you need to copy A20, C20 and E20 from Receipt into L5 of Log, should the other columns be populated as well? Columns like B5, E5, etc?

Also, you do not need to have separate buttons for update and refresh. Once you click on update, the macro can transfer the data for you and then clear the contents of the cells.