Return a column of data from another sheet

[jl2509]

Hi All,
Any ideas how I can retrieve a column of date from another sheet based on the sheet name

On the Sheet named "Dashboard" In Cell B4, there is a data validation list which has the Sheet names listed
When a sheet name is listed i.e. "Open Orders" I need to pull all the rows from Column F of the Sheet Named "Open Orders".

Is it possible to have all of the data collected dynamically from Column F starting at F2 to include all cells as the data will grow/shrink.

Any help is most appreciated

 

[Fluff]

How about

=LET(d,INDIRECT("'"&B4&"'!F2:F10000"),FILTER(d,d<>""))

 

[jl2509]

Thanks Fluff, works a treat. Great solution
I'm going to try and get the range dynamic though rather than stating a fixed range.

 

[Fluff]

You're welcome & Thanks for the feedback.