Copying data into a new row - macro

Title's not that great. Not sure how to describe it well.

What I want to do is for a macro to run and for that macro to copy data and place it in a specific place. For example i want it to take the the 20 from "Village Headquarters (Level 20)". Another time when I run the script the 20 might be a 30. I there a way to do this? To define a place to take the data from within a cell.

My other question is, is there a way to have a macro automatically paste data one row down from the time it was run last?

Thank you

What I mean is i would copy Village Headquarters (Level 20) into a cell and then have the macro copy the 20 into another cell. this 20 could be another number instead of 20 but the "village headquarters" and such would stay the same.

Would that code work as a macro as such. Like when i run the macro will it auto do that code r what.

Sorry for my stupidity

there's the document I want to put the 26 in Timber camp (Level 26) into a new row under where it says timber. But have that automatic

should I be using VBA within excel to do this or something?

Sorry for the triple post. I think I'll reword what I want to do. What i want is for this:

Village Headquarters (Level 20)
Barracks (Level 25)
Stable (Level 20)
Workshop (Level 9)
Academy (Level 1)
Smithy (Level 20)
Rally point (Level 1)
Market (Level 17)
Timber camp (Level 26)
Clay pit (Level 26)
Iron mine (Level 25)
Farm (Level 30)
Warehouse (Level 28)
Hiding place (Level 9)
Wall (Level 18)

to become:

20
25
20
9
1
20
1
17
26
26
25
30
28
9
18

^ Does that make sense? Is it possible?

Nevermind. I've figured out how to do other automated stuff so I don't need this. Thanks for trying to understand my logic +1