I have a number of sheet tabs and one of them is for data input. All the
other tabs (graphs, tables) are fed by the input tab. On the input tab each
column represents a month.

On another tab I have a table with loads of different data, monthly data
(only the current month data) from the input sheet. This table should be
updated with new numbers each month from the input tab. I am looking for a
way (formula) where I only need to add the name of the month or another
identifier to the table tab and then the table will be fed with that specific
months data from the input tab.

Thanks
Mickey