I pull physical stats of network devices daily. Each time I pull data, it goes into a new Tab. All tabs are formatted the same, though there may be differing numbers of rows, and corresponding device data may be on a different row in each tab.

Data is formatted by row, with an authentic MAC address in the A column, and different stats through the columns. A device will only appear once per tab, and may not be on all tabs

Example of data format on each tab:
MAC Address____XXXX__Pwr1_Pwr2__XXXX__Pwr3._Pwr 4
1234.5678.0001....xxxx....52......26......xxxx......3.......34
1234.5678.0002....xxxx....47......27......xxxx.....-10.....35


My end goal is to generate a trend graph for a single device by simply entering its MAC address into a specific cell and maybe clicking a macro button. This would generate a table by searching each tab for a match of that MAC in the A column.

A match would result in 5 cells from the matched row to be entered into the report table. On and on through each tab until I have a trend table.


Something like the format below:

Date/Time___Pwr 1_Pwr 2_ Pwr 3_Pwr 4
02-10 0900___54____25_____0_____35
02-10 1600___48____25_____-1____36
02-11 0930___35____26_____-9____35
02-13 1000___52____27_____7_____34
02-13 1200___42____25_____10____37
02-13 1900___49____25_____12____38


Since the number of tabs changes daily, I dont want to be required to update a formula or macro each time I add a tab.

I've worked a little with loops and lookups, but this is just a bit too complex for me to take all the smaller ideas and link them together. If I can get the table generated, I can handle the chart.

Thanks for Any Help