I need to copy a range of cells data from one worksheet to another.

In the source worksheet, I have a specific number of columns but the numbers
of rows should be dynamic, it should be able to expand until it finds an
empty row.

It then takes this range of cell data and copies it to another worksheet
starting at a specific cell (namely, A9)

How do I do this?