title: How can I access data that changes locations and header names across workbooks?
body: <p>I am trying to access data that changes locations and header names across different workbooks. This is part of a bigger project but this is the only part I cannot figure out. I have attached images to help clarify what I mean. Let's say that I'm trying to access the range that contains the Net Worth/Balance so I can do some calculations with it. How do I do this if the headers change across dozens of workbooks? On top of that the headers aren't always the first rows with any writing on it. Sometimes there is info in the upper rows that are needed for the workbook but not my purpose.</p>
  
  <p><img src="https://i.stack.imgur.com/4Oa8r.png" alt=""></p>
  
  <p><img src="https://i.stack.imgur.com/F7tYx.png" alt=""></p>
  
  <p>The programmer in me wants to use a dictionary and find all variations of the "Net Worth" title that exist but is that the most efficient way? Should I just use a super long if then statement?</p>
  
  <p>Thanks in advance for your help!</p>
  
  <p>****Also if anyone is wondering if I should even use a macro for this please remember this is part of a much larger project where there are many calculations and they are repetitive across workbooks. My only difficulty is finding where the data is in each workbook.</p>