Create new workbook and import data into it

Item:Take the text file and popluate it into one of the sheets in the new workbook - don't know how to do
_______Let's see a sample of the text file. With this text file, does it matter what data from it goes where?

Item: Take the data in the new sheet and create a summary in the remaining sheet in the new workbook - don't know how to do
_______This is possible but it requires the the format of the new sheet to always be the same each time.

Item: In order to create the summary, it would have to apply formulas to the new workbook - don't know how to do.
_______It would be better for this project to use a template that gets save after it is filled in. This means that you do not start a new workbook but rather save a template AS some name.

I would need a sample of the text file and a sample of what the workbook(with analysis) would look like in the end.