title: Create VBA for multiple sheet and copy paste in new column with formula
body: <p>I have an excel with multiple sheets and would like to copy or better say want to extend the last column every month.</p>
  
  <p>Eg:-
  I have a sheet with sheet named sheet1,sheet2,sheet3,sheet4,sheet5...every sheet at the end of the month has formulas.Once a month is over I would like to add a new column with new month and copying the existing formula to the new column.Let say I have last month Jan and I need VBA to add new column with month as Feb and copy all the formula to the new column.</p>
  
  <p>Sometimes I also need to copy multiple column (eg:-Column C-J) and replicate the next 8 column with new month and formula.</p>
  
  <p>Tried with recording macro but the issue is it doesn't create a new column for every month it just copy paste it in same column rather than creating a new one for every month</p>