Macro To Merge Csv To One Master But Limited

I am in need of a macro to merge approx 30 csv files, kept in same directory. Csv files are identical format, have one populated worksheet, 6 columns, no headers. However, number of rows will vary. I would like to merge them to a separate excel workbook, with data stacked to one master sheet. Is it also possible to only bring over rows that have than 0 in column E. I have the following macro to merge however, it merges .xls files and it brings over all rows.


Dim ToBook As String
Dim ToSheet As Worksheet
Dim NumColumns As Integer
Dim ToRow As Long
Dim FromBook As String
Dim FromSheet As Worksheet
Dim FromRow As Long
Dim LastRow As Long........