Macro to separate, concatenate, and change sheet names

I am brand new to Macros - in fact, I really do not know what I am doing with them at all.

I would like to see if I can create a macro to even more simplify the repetitive tasks that I need to do. This will reference the Macro solution that was given to me in Post #4 on this link: http://www.excelforum.com/excel-gene...ml#post3679700

I gave a simplified version of what I am actually trying to do because I didn't expect as awesome of an answer as I got - and, it seems, with using a Macro, I could get Excel to do even more for me.

Here is a table of exactly what I am looking at


SHEET 1

A	B	C	D	E
Date&Time	Ask Price	Bid Price	Ask Volume	Bid Volume
2007.03.25 21:00:03.496	1.64845	1.64785	1	1

That is the basic setup and it goes for about 500,000 rows and I have almost 5,500 workbooks. So the idea of automating my tasks as much as possible is extremely appealing

Following the pattern on the link that I gave above, I would like the following:

ASK (This is Sheet #2 having been renamed)

A	B
20070325	210003;1.64845;1

(concatenation of Time, Ask Price, & Ask Volume...all separated only by a ";")

BID (Rename of Sheet 3)

A	B
20070325	210003;1.64785;1

(concatenation of Time, Bid Price, & Bid Volume...all separated only by a ";")

And, with the answer, could you also share with me precisely how I am supposed to enter this Macro into excel and also if there is some way of being able to this in a batch, rather than each file individually?

thank you very much and I deeply appreciate any help that anyone is able to give to me.