Hi guys!

Good day!
I'm newbie in macro and I need a help regarding my task. I want to do a macro on how to copy data from multiple workbooks into one master file. I have a form for invoice with data on columns D-G (Details, Area Code, Account, Amount) with data that can be inputted from rows 45-70 depending on the number of request. The number of forms varies day to day and I need to consolidate all those forms into one master file. I want to copy the data from that forms into a master file workbook with the header (Account, Area, Amount, Descriptions) from A5-A8. The file path can also be changed so I guess it should be reflected in masterfile so it can be easily change depending on the location of the source file. I hope you can help me on this. Thanks in advance.