Consolidating tabs

I am using a security program that provides info in PDF form. Each morning it spit out approx 12 pages, which consists of a one long table with 4 colums.

I then convert that file into excel. The problem I have, is that when I convert to excel, it puts each PDF page on a seperate tab. I need all one one excel page to allow me to dicipher the info. All 12 tabs can be consolidated onto one new sheet, or it can be appended to the data on the first page...I just need one long spreadsheet with all the data.

Is there a macro i can use to move all the data to one excel page?

I will need to do this daily, each time with a new file.

Thanks

I have tried the code on Ron's page, and cant get it to work...then again, not real familiar with VBA.

This is what I am doing:

I open the workbook and then open VBA, first code goes in module 1, and the lastCol function into module 2 (the last LastRow and LastCol are 2 different functions right...you only insert 1 of them?) Save both, close VBA and i am off to the races!

When I run the code I get a list of the tab names, (sheet 1, sheet 2, sheet 3 etc to sheet 30) in Column "H" from row 1 to 30 on the newly created RDB merge sheet!

Then I tried to chage this:

'Fill in the range that you want to copy
Set CopyRng = sh.Range("A1:G1")


For this:


'Fill in the range that you want to copy
Set CopyRng = sh.UsedRange


and it didnt work at all!

THanks for your guidance.

M