Importing data from multiple workbooks into a summary workbook

Hello to you all!

I'm looking for some help. I've searched the forums and found several questions similar to mine but I have no idea how to apply the suggestions to what I am doing.
Please keep in mind that I do not (yet) know anything really about macros, VBA, et al.

I will have several workbooks (about 20) that I want to import in one summary. As there are headers in each workbook I don't want that information imported.

I've attached the rough draft. If anyone could help I would be ever grateful!

Also, is there a way for it to figure out that nothing was entered on a row and NOT import that data? If not, how do you write a macro to sort.

Thank you so much for any help!!