How to find a variable name within a list and export a table of data to another sheet

Hi,

I have a spreasheet that I use to import data from one sheet to another, that could be in any order and organise the results in a logical order.

I am using a Vloopup formula to find single values for example =VLOOKUP($A5&B$4,INDIRECT("'"&$B$2&"'!$A$1:$T$5000"),2,FALSE).

This works fine for single values, but I want to find and export a table of data? Is there a way of finding a varibale in the list and then export data from a specified location to another sheet?

In the simple spreadsheet attached, I want to copy the annual data from 'raw data' and paste into sheet one, but that data could be could start anywhere in column B next to the variable name 'Annual sales'

Thanks for you assistance.

I am fairly new to excel and my naming convention might not be correct.

Is the question and information clear enough?