Moving a data table to a different workbook

I found myself in a similar situation. Out in the big world there is a database to which I do not have access. However people will send us emails with human-readable reports attached to them. So I have to parse these reports back into data.

it started with one report that had several different data sources let's call them A, B and C. Then the next report came along and it needed A and D and the next report need A, B, F & G, and so on. So I found myself running he data parser in one report and copying and pasting it into the other reports that needed it, etc.

So I bit the bullet. I took the data parsing code out of each of the reports into separate spreadsheets. These spreadsheets store the data in an Excel Table. I then created an Access Database and linked the tables in the Access databases to these separate Excel Tables. Now my data is all in one place and it is easier to pull it together whenever a new report comes along. Some of the tables are "core" and show up in multiple reports.

If you do not have MS-Access, you can used MS-Query (part of Excel) to read a directory containing text files if you set up the text files as a data source. Parse the data in Excel save as CSV use the CSV files as the data sources for the reports.

If you are interested in how to use MS-Query with a directory of CSV files, I can put together a word document describing the procedure.