title: Google Sheets - Loop through Sheets consolidating data
body: <p>I am after a bit of help looping through sheets in google.</p>
  
  <p>Scenario - I have around 20 tabs all with the same layout, I need to gather information from all of them and place into 1 master sheet.
  The data starts on row 2 (headers) and can be variable in length (End column if needed is column "Z" )</p>
  
  <p>The code can either create a new tab to place all the data or I can create a specific tab.</p>
  
  <p>(might need to take into account that I need to not include some sheets - I can define these)</p>
  
  <p>In excel it would be a simple
  Create new tab (Called Summary)
  Loop through tabs
  If tab name is not on my exceptions list then copy range on sheet (Dynamic Range)
  Place range on next available row on Summary tab
  Repeat until done</p>
  
  <p>Any help appreciated</p>