Hi,
Below is a nested loop that 1) loops through a list of worksheet names, 2) gets the last row of data from each sheet and 3) is supposed to aggregate each row of data into a DashBoard sheet by transposing it.
I am trying to get each subsequent bit of data to get pasted into the next column...