Opening a new table using a drop down list

Hi guys,

So I'm tasked with making a data input table for each month of the year on a worksheet, that feeds a larger table on a separate worksheet. Problem is that they want one single sheet to display the data input table and be able to switch months with a drop down list, instead of having to go to separate sheets for each month (hope that sounds clear enough). I have done some research online but I haven't found anything helpful. If anyone could help I'll definitely appreciate it.

Thanks

*I'm attaching simple example of what I mean*

put this

=IFERROR(IF($B$1="January",'January'!A3,IF($B$1="February",'February'!A3,"")),"")

in the first cell of your result data (tab data) cell A4 - in this case, copy accross to the end of your result data. If you want more months you need update formula about march, april etc.
but remeber to use apostrophe, because if you don't use it you will get Update window. It's very annoyingly