I have a client that has a workbook with 190 worksheets in it. I am need to combine all the data from each worksheet into a new worksheet with a flat table from each of the worksheets. Each worksheet looks like this
worksheet.jpg

I need the flat table to look like this: (I have only created the first line)
excel.jpg

I am not a programmer so I have not tried creating a macro. I have tried using macros to combine all the worksheets in one but that is not really what i am looking for since it copies the worksheets as is. I need the info reformatted into a flat table. Hope this makes some sense. The purpose of all of this is to import all the data into a sql database and that can not be done in it's present format.

Many thanks,
Houston