Hello all! Wondering if I could get a quick hand modifying a bit of code. I'm hoping it isn't too complicated and ends up being nice and straight forward.

I have three workbooks that need to have their data consolidated into one master workbook.

The master file name is: MASTER ver 2.0.xlsm
The three books that feed into it are: RTC, BELL and WOOD (all are .xlsm)
All of the files are located in a folder on the desktop labeled: SB TRACKER

The three workbooks being copied from may contain different amounts of data so I need help with two things.

1) making the macro identify only data (not blank rows) for the selection
2) when copying into the MASTER ver 2.0 it copies to the first available row.

Here is the macro i'm starting with, still very basic:

Sub COPYDATA()
'
' COPYDATA Macro
'

'
    Windows("RTC.xlsm").Activate
    Range("B5:O7").Select
    Selection.Copy
    Windows("MASTER ver 2.0.xlsm").Activate
    Range("B5").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
    Windows("BELL.xlsm").Activate
    Range("B5:O7").Select
    Application.CutCopyMode = False
    Selection.Copy
    Windows("MASTER ver 2.0.xlsm").Activate
    Range("B8").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
    Range("B11").Select
    Windows("WOOD.xlsm").Activate
    Range("B5:O7").Select
    Application.CutCopyMode = False
    Selection.Copy
    Windows("MASTER ver 2.0.xlsm").Activate
    Range("B11").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
    Range("B14").Select
End Sub
If anyone can help me out i would greatly appreciate it! Thank you!

Evan