Excel VBA: copying raw data into specific cells of a target sheet

I am a beginner with VBA so any kind of tip might be helpful to me.

I have two worksheets within the same workbook, namely sheet1 ("rawdata") and sheet2 ("Overview).

Every morning, I am copying downloaded data into the sheet1 ("rawdata"). Here the number of rows vary but heading/columns are always the same. After this I need to copy specific cells into another worksheet. Here are the "rules" I was thinking about:

1.) I want to always copy cells from the rawdata sheet E9, W9, X9 and Y9 into a specific cell in the target sheet

I had something like this (which worked):
Worksheets("overview").Range("X10").Value = Worksheets("rawdata").Range("E9").Value

2.) I want to copy always the value within column E in the lastrow. However, the last row is varying from rawdata to rawdata while the column (E) always stays the same. I tried something like this:

....= Worksheets("rawdata").Range("E1").End(xlDown).Value (is not working :-()

3.) The script should be linked to the button, when I click the button again for insert the data from the sheet rawdata, the data should be insert in the next (following) column of worksheet overview.

Do you think you can help me out with some codes or helpful tips?