Thank You for this opportunity. I'll need to get two ranges (columns) of a
first sheet of data from about 300+ (it could be divided by 50+) closed files
that are protected (not the data) to one new workbook. In addition to others
singles fields to be incorporated besides the data as follows;

Form Source;
Row1=a (text)

Row2=b(text) &
=c(text)

=d(text)

Row3= Type1, Type2

Range1=Columns1,2,3,4,5 /Range2=Columns6,7,8,9,10

New WB; all Form Source by columns

texta,b,c,d,Range1(and)
texta,b,c,d,Range2

Regards,