Copy and paste to new spreadsheet based in date and other criteria are met VBA

I need a macros that would allow me to do the following:
I have a excel spreadsheet-1 that contains a list of materials. What I like to be able to do is put a button on another spreadsheet-2 that will check for and move rows based on the date (dd/mm/year) in a certain year (column A) and the status (‘used’ – column E) to that spreadsheet-2. Additionally when the check is performed, it should add the latest “used” materials right under the last row used (in ss-2). And lastly, delete that copied row from spreadsheet-1.
I haven’t been able to find something that would do exactly that.
Thank you so much for your time.