Create, rename, and save new worksheet and workbook

Hi,

Capture.PNG

The above image contains the store information of a series of articles. I would like to extract the store information: Ship to Name, Ship to Address, and Ship to Address 2 of each article, then save this file into a new workbook, renaming the new worksheet and workbook to this article number. Such as the following:

2.PNG
3.PNG

Can't think of anyway of doing this...Please help!