Automatically transfer data to another tab via drop down

Hello,

I do not know much about excel I'm afraid and have been given a task at work but unfortunately am struggling big time - tried to google it and read through several websites with no success.

I have a spread sheet with lots of different projects on - I created a drop down menu where I can choose departments in which the projects fall into such as: accounts, finance, HR etc and also one called CLOSE.

As soon as I select close, I would like this project to automatically go to the second tab of the workbook called 'CLOSED'. That way all closed projects automatically go onto another tab.

Can someone please let me know if this is a) doable and b) how to do this, please note I am completely clueless when it comes to macros!

Many thanks in advance for taking the time to read this even!