Pull a specific data range from spreadsheet and offset when the month changes??

[blimey88]

Good afternoon all,

I want to select 3 columns of data from my spreadsheet which will be displayed in a chart on my dashboard, for example Column headers are Jun 19/Jul 19/Aug 19, when I get in to the month of September I want the selection to move along one column and then select Jul 19/Aug 19/Sep 19? I'm aware of what I need it to do but cant work out the formula. Please help??

 

[RasGhul]

Can you post some sample data?

 

[blimey88]

=OFFSET($B1,0,$Q$41,1,1)

This is what I came up with in the end and this is now displaying the data I required in the relevant chart within my dashboard.