Rearrange Data in separate excel file

Hello:

Please refer to attached file.

I need to copy the attached file in following way and save the file as C:\Sales Detail_DQOZ_$.xls where $ in the file name
will refer to sheet name. In this case the file name saved would be Sales Detail_DQOZ_06092014.xls as sheet name is 06092014.

First I need to look for Z1/Groups in Column A and look up for Report End.
Now copy the data in between Z1/Groups and Report end in the above assigned file starting in cell A1

Next i need to look for Z1/Financial in Column A and look for Report end.
Copy the data in between in the assigned file as shown.

Please refer to attached 2 files to see how i want it.

Let me Know if you have any questions.
Thanks.


Riz