title: Copy data from an Excel sheet to different files
body: <p>I have an excel sheet which has some huge data. Data is organized as follows, 
  A set of 7 columns and n rows; as in a table, and 1000s of such tables are placed horizontally with an empty column to separate. A screenshot is below..</p>
  
  <p><img src="https://i.stack.imgur.com/61Akv.jpg" alt="enter image description here"> ...</p>
  
  <p>I just want to have data of every 'table' saved into a different file. Manually it would take ever! So, Is there a macro or something I would automate this task with.
  I am not well versed with writing macros or any VBA stuff.</p>
  
  <p>Thanks,</p>