vba code to convert 'n' number of dataset into tables automatically.

Hi All,
I have series of dataset as output from ERP system.
for eg dataset as
A10: R13
A17: P33
A36:I39

The number of rows and columns in each dataset is not fixed.
I want each dataset to be converted into seperate tables automatically.
The first dataset always start in cell A10. All the dataset has one thing in common and that is each dataset's first row has same fill color (Interior Color Index= 10921638)

Thanking for your support in advance.

Hi Olly,
Is it possible to skip one row and then convert dataset into table.
Because for example dataset starting from A10 has title say "Incomplete PO" in cell A9. With this code table is created from cell A9 itself.

Thanking you for your support in advance.

Hi Olly,
Is it possible to neglect the one row above each datasource.
The problem is that if datasource starts from cell A10 but it has title in cell A9 say "Incomplete PO".
With this code table is created from cell A9 which actually should commence from Cell A10.
Waiting for your reply.
Thankink for your support in advance.

Hi Olly,
Thank You very much for your valuabel inputs and time.
I am attaching sheet (130951_1.xls) as I get it as output from ERP system.
My intention is to convert each datasource in separate table.
As conveyed number of rows and column in each data source varies from project to project.
The table must have row filled with gray interior color as header row and all rows highlighted in yellow color as data in that table.
The row header that is gray colored row is same as I get it from ERP report.I have intentionaaly filled rest of the rows with yellow color.

Appreciate your valuable time and inputs once again.

Hi Olly,
Please find revised attachment.
Inconvinience is regretted.

Hi Olly,
Thank You.
The code works perfectly.
Once again Thank You very much.

Is it possible to activate the "Total Row" property of each table created by this code using vba coding. This would help user to select the required function, say count or sum based on heading of table in that column ?

Hi Olly,
I have attached both raw and formatted file using macro with total rows.
Few of the dataset are not converted to table (titles of such dataset are highlighted in yellow color).
In few data sets rows are distorted which I have highlighted in red color.
Please help me to fix this one.

Thanking you for your support in advance.

Hi Olly,
Thank You Very much. The code works and data is now not misaligned.
Once again Thank You very much. Sorry to get back to you after some time.