Copy LInes From One Sheet To The Last Line In Another Workbook

Hello everyone,

I have searched the forum for posts that explain how to copy lines from certain cells to other certain cells at the end of a different workbook but can't seem to find the answer i need.

Here i am trying to copy between B25 - G25 through to B40 - G40

I need them to go into a seperate workbook underneath the previous entries and not overwrite anything.

A macro of some sort would be the best for me if this is possible.

I have included a copy of the 2 sheets for ref:

I would very much appreciate if someone could point me in the right direction.

Many thanks
Mark