So i need to run a little quick and easy macro in excel to help me with this
data i need to compile. Its somewhat hard to explain, but basically i need
to figure out how to tell the macro to literally just hit the arrow right
key, 4 times, instead of having it recognize specific cells.

I have 30 workbooks with 30 sheets per workbook. Each sheet has the same
4x10 rows/columns filled out with their own unique data. I need to copy and
paste these 4x10 blocks of data and paste them on a new sheet, stacking them
horizontally.

I can get the macro to copy and paste the first block of data, then switch
to next sheet, but i cant get the new sheet, where i just pasted the data, to
move over 4 columns to the right, to get ready for the next run of the macro
to past the 2nd sheet of data.

Does this make sense? If so, please offer any help you can.

Thanks,

-Adam