VBA Excel Enhanced Lookup user defined function

ENHANCED LOOKUP EXCEL VBA USER DEFINED FUNCTION - In a "source" sheet are downloaded financial data for multiple securtities. Example: date, volume, close, high, low - For each security, the subset of data may be different: Example: security 1 has a set of monthly close price only (Column A: Date, Column B: Price) security 2 has daily prices with high, low, volume, close (Column D: Date, Column E: High, Column F: Low etc.) - We want to develop a VBA excel user defined function as follows: Value = DataPoint(Sheetname of Database; Ticker; Field; Date) - Clean example of the data source and it's format is provided, as well as how we want the function to work in the attached spreadsheet - We want the code to be visible in the vb editor - BEWARE: (i) this is not a plain "indexmatch" type of function as the funtion will need to identify a correct subset of data within a data source sheet first (ii) however this is a reasonably easy job for the right VBA experienced freelancer (iii) we are open to have REASONABLE format constraint on the source of data