Macro that Copy and Paste Values

[Nuccio92]

I have attached an example excel workbook of what I am attempting to do. I am trying to pull information from worksheet "Data By Stubhub Order" into worksheet "Data by Seat".

I need to pull from "Data by Stubhub Order" EI2, EQ2, EY2, A2, B2, C2, D2, E2, F2, G2, H2, I2, J2, K2, L2, M2, N2, O2, P2, AC2, BN2, BO2, BP2, BQ2, BR2, DE2, DF2, DG2, DH2, DI2, DJ2, CG2, CO2, AND CW2 into "Data by Seat" A2 - AH2 respectively.

Then I need to pull from "Data By Stubhub Order" EJ2, ER2, EZ2, A2, B2, C2, D2, E2, F2, G2, H2, I2, J2, K2, L2, M2, N2, O2, Q2, AC2, BN2, BO2, BP2, BQ2, BR2, DE2, DF2, DG2, DH2, DI2, DJ2, CH2, CP2, and CX2 into "Data by Seat A3-AH3 respectively.

I need to do that for every seat in that row. So there is a possible of eight seats in each row, and the bold cells are the only ones that change until you move down to the next row. Obviously if the first sell is blank I don't need to pull all the information.

For example, in the sample I attached the first row I just need to go up to the fifth seat, the second row just the first seat, but in the third row I need eight seats. If something doesn't exactly make sense or not really possible using a macro please let me know. I tried to explain it the best way I could.