How to combine several workbooks in a folder into an existing Workbook.

[Grasshopper77]

I'm new to macro's and appreciate any help I can get! I know this seems to be the same question posted everywhere, except everywhere I go, the code doesn't seem to work for me, which is why I have created my own post. Now the task. I have a folder with approx. 12 workbooks. Each workbook has one sheet. The titles and number change every week. What I'd like to do is create a macro that copies the header (A1:U1) and data off the first workbook/worksheet and place it into my existing worksheet. Then copy just the data from the other workbooks/worksheets. The data rows are variable, with a slight issue on blank rows. The next to last row has totals (F:I). I don't want to copy that data over. Also, my worksheets, skips a row and has data in only A:B (more roll-up data). Again, I don't want to copy this data over either. Thanks in advance for any help!