Lookup from badly formatted spreadsheet

Hi guys,

I'm trying to find a way to pull some data out of an inefficient formated spreadsheet with large amounts of historical data, into a new tab in a format enabling me to do e.g. pivot tables.

I've attached a file that can hopefully make it easier to understand what I'm trying to achieve.

Tab 1, DATA v1: This is the formatting/layout of the data I'm trying to pull into tab 3 (RETURN)
Tab 2, DATA v2: This is how I potentially can "reformat" the data source
Tab 3, RETURN: This is the sheet I want the values from the data tab to return.

Thanks,

Chris