Looking up specific period financials from multiple period worksheet

I would second the request from peiyezhu​ that you provide a working copy of your workbook. 

In addition, I'm speculating here, but this appears to be a situation where you are wanting to pull data (for reporting purposes) from data that has already been summarized elsewhere in the workbook. This leads me to wonder whether it mightn't be more effective to produce your higher level, more focused summary, directly from the raw data. What led me to speculate along those lines was your suggestion that  you might try concatenating headers into "JulyADRUSD" in order to extract the desire set of numbers; that sounded like making something that should be simple -- extracting data from a database according to certain identifiers --and making it overly complicated.