macro that will and copy rows only if data is in a cell

I have a range that i need to run a report on regularly. This range has sporadic amounts of data in it. one time there may be 60 rows of data, next time there may be 250 rows of data. i want the macro to select and copy only the rows that have data in them.

i currently have a macro that i just set a range A25:A400 so it goes down and copies all these rows so it covers me .... but it is causing me problems by copying all those empty rows.

The macro will need to start at A25 and go down from there A26,A27 etc select and copy only rows that have data and stop. i need the data copied to a seperate sheet named "Combined Scoreboard" inputting at A25.

Note: i only need to check to see if there is data in the A column cells starting at A25 and working down.

Thanks