Excel VBA Macro to Loop and Copy Data to a new sheet : I have an excel workbook with multiple tabs formatted like this:


  [1]: https://i.stack.imgur.com/9MAWi.png
  

I'm learning vba but don't know the excel functions well enough yet to loop through the rows and copy the data reformatted to a new sheet into this format:
 
  [2]: https://i.stack.imgur.com/Uy6aD.png


Specifically I think i need to 		
a. Initialize the range of worksheets
b. loop through them
c. store column headers for b through G into a variable so when the x is found it can be concatenated or copied over
d. handle the blank spaces so that the last value is used for each one

Any help appreciated. Thanks!

