Macro to move lines between tabs

Hi all,

I hope you are all well. If you can help with this question it would be appreciated. Is there a way of using macros that will swap a line from one tab on a spreadsheet to another tab on the same spreadsheet based upon if i set a cell to say either open or closed.

I have two tabs (open / closed) in a sheet and am setting up an issue log. The issue is entered in the open tab but when i set the issue to closed i would like the whole line to transfer to the next abailable line in the closed tab.

Many thanks,

Chemist