So I have 5 sheets, call them "Title Page", "Page 1", "Page 2", "Page 3", "Page 4", etc.

On the first sheet ("Title Page") I have a list of pages used in column A. This column is populated using a drop down menu.

What i have so far is this, when someone opens the spreadsheet they will only see the "Title Page" sheet, the other sheets are hidden, which is what i want.

On the "Title Page" in column A, the user will then select the pages they want like so

__A__
Page 1
Page 3
Page 4

i.e. I do not want sheet "Page 2".

I then want a VBA macro to look at the values here and unhide the pages listed. Is this possible?
I am a total novice at VBA scripts, I know how to open the VBA section (Alt + F11 and insert a module) that is about it. Any help would be amazing!