copy a block of cells that can vary in rows and columns

[Megatronixs]

Dear all,

I have attached a workbook as an example.
From the sheet1 I need to copy a block of information. Some times the information has more rows or more columns. I would need to copy the last cell in a row and the last cell in a column to form a block that I can paste in another workbook.
I can get the last used cell in a row and in a column, but can't figure out how to select the whole block of cells.
Great would also be if there was a text in a cell (column B) and then start copying from there.
Can one help out pleases?

Greetings,
megatronixs