Using VBA to move line to another spreadsheet & creating search bar.

Hi all. I am familiar with excel but have very limited experience with VBA and I need some help with making my spreadsheet (which I hope I have attached correctly) easier to use.
I would like the following:
1. Once a job from 'Table1' on the 'Job Requests' spreadsheet is marked as 'Completed' in the status column, it automatically moves to the next available line in 'Table2' on the 'Completed Job Requests' spreadsheet.
2. The row that the completed job was occupying on the 'Job Requests' spreadsheet gets deleted once it has moved to the 'Completed Job Requests' spreadsheets.
3. On the 'Search' spreadsheet I want to create a dynamic search bar that will search the columns 'Department', 'Job #', 'Name', 'Unit #' & 'Date Finished' from 'Table2' on the 'Completed Job Requests' spreadsheet.
4. I need the hyperlink to remain active on the completed job has moved to 'Table 2' on the 'Completed Job Requests' spreadsheet and when showing the results from the search bar on the 'Search' spreadsheet.
Because I'm terrible with VBA I'm not sure if all this is possible or how to go about it.
And I apologise if something I've written doesn't make sense or I have done something wrong in creating this post.
Hoping someone can help me out.
Thank you in advance.
Mary

Hi @Clappo77! Look in the file, is that what you wanted? I hope I helped you. Good luck.

My sugggestion for Search sheet.

Please Login or Register  to view this content.

You're welcome and thanks for rep+.

Good luck and thanks for rep+