VBA to read "form"
 

Hi-

I have a "pretty" excel spreadsheet, that to the users, looks like a form.
The top half of the "form" has Company info and the bottom half has a "table"
showing multiple serial and model numbers.

This has worked wonderfully in a manual system.

Now, I would like to learn how to move this data into a "useable"
spreadsheet for me, while keeping it "pretty" for the users entering the data.

Basically, I need a crash course on how to:
-Prompt for what file to look at
-Read the top half of that file, placing each needed cell into a new workbook
-Loop thru the bottom half of that file, placing each need cell into a row
with the above info

Befo
Auto Parts - Store #1
1234 Hollywood Blvd.
123-456-7890
etc.
-------------
Q-Oil 121212 V-Oil 445544
Wiper 383838 Fuse 999999

After:
Auto Parts Store #1 1234 Hollywood Blvd. 123-456-7890 Q-Oil 121212
Auto Parts Store #1 1234 Hollywood Blvd. 123-456-7890 V-Oil 445544
Auto Parts Store #1 1234 Hollywood Blvd. 123-456-7890 Wiper 383838

This file I can Pivot and put into Access.
I would like to open another file (Store #2) and add that data below Store #1

Any help would be appreciated.
If I get a "shell" VBA that is well explained, I hope to be able to tweak
the rest (Although this will be me first real VBA code - so go easy on me).
Thanks a bunch.