VBA to Insert Table on Every Worksheet

[Small Paul]

Hi

I have a table of data (variable number of rows, columns A-R) with an identifier in column K (again, variable row count e.g. A, B, C, C, C, D, D, E etc.). The table is then split into new worksheets with each worksheet named according to data in column K. So far so good!

I now need to add a new table (columns A-K) onto each of the worksheets, beneath the existing data. This will then be:
a) populated by data from each data set (columns D, E, B, G, H, I, J, L, M, N, O)
b) exported (table not worksheet) and saved as an individual pdf

Any help / advice / pointers would be greatly appreciated.

Many thanks
Small Paul.