Using excel to write wiring connection plan

He there, hope this is not going to be a too long post but will try to minimize it.

I'm trying to write wiring plan of connections in excel.
Have been able to manage data sort in the way I need to once I have all data in one huge table. But, now I'm stuck with automatically filling data table from sheet with wiring connections.

Here is an example(just one bit of it) what it looks like(picture)


http://www.deviantpics.com/hbZ


Ok, this was drawn in autocad, but I will make a table and do that in excel. It will contain only data in numbers and text.
As you see, this tell you destination A and B of one cable, type of cable, and its name.

And the most important thing, on the first sheet there is various number of these tables, all king of terminal blocks. X100,X110..x200. And for every single one, I want excel to create on its on sheet name of terminal block the table described below.

I want to export that data to another sheet in excel that will have name of terminal block: "X220". And on that sheet will be create table like this one(picture):

http://www.deviantpics.com/hbo


Can it be done?