Write a EXCEL macro to Parse data

Hello, I require an EXCEL macro/VB script guru who can write an EXCEL spreadsheet working example to: 1. Have a EXCEL sheet and a text 'box', where a user can paste in new data - press button, and the excel sheet parses the data into 3 tabs. 2. When user has new data, he can past it new data into the BOX - and it APPENDS the new data into respective tabs/tables Notes: Data example in [login to view URL] file. Will support more devices that 3, and devices ordering or device count may change (structure will not change) I have created and attached an example spreadsheet of how I want the output to look. The challenged for smart individual would be how to parse the data with built in EXCEL macro's. Order does not matter on the finale output tables. Note, the number of interface name e.g.. em1 and em3 etc. can be different per box. You will notice the the device with IP [login to view URL] has two extra interfaces than the others in the INT table