copying data into next available blank row-do this with several worksheets until all are 1

[barbibchn]

Hello all,
not sure if this is the correct place to submit this - however here is my question:
I would like a macro to select all rows from row 9 and copy down to the first blank row (end of data in this worksheet) then paste it in a "Master Worksheet". I would like to have a button to do this so when others are doing this task I can be ensured all data is pasted into the one master sheet.
I am sure this is very simple to all of you; however, I really don't know that much about Excel doing these kind of things.
thanks in advance for any assistance.



Thanks for your assistance-:-)