This script collects data from each column on each worksheet. The script has to be modified if used in real MS Excel. This is the result: Sheet 1 ['192.168.1.1', '10.1.1.1'] ['10.1.1.1', '192.168.1.100'] ['tcp80'] Sheet 2 ['1.1.1.1'] ['2.2.2.2'] ['Tcp80']