title: Excel VBA Sum from Multiple Sheets
body: <p>I am trying to create a function or functions that can sum daily hours from time cards for each client to come up with the total hours worked per day.  Each client has it's own sheet inside of a single workbook.</p>
  
  <p>Currently, I have a function that determines the sheet that goes with the first client (the third sheet in the workbook):</p>
  
  <pre><code>Function FirstSheet()
  Application.Volatile
  FirstSheet = Sheets(3).Name
  End Function
  </code></pre>
  
  <p>And one to find the last sheet:</p>
  
  <pre><code>Function LastSheet()
  Application.Volatile
  LastSheet = Sheets(Sheets.Count).Name
  End Function
  </code></pre>
  
  <p>The part that I am having trouble with it getting these to work within the sum function.</p>
  
  <pre><code>=sum(FirstSheet():LastSheet()!A1
  </code></pre>
  
  <p>That is basically what I want to accomplish.  I think the problem is that I don't know how to concatenate it without turning it into a string and it doesn't realize that it is sheet and cell references.</p>
  
  <p>Any help would be greatly appreciated.</p>