Problems populating my reports worksheet

%3CLINGO-SUB%20id%3D%22lingo-sub-793569%22%20slang%3D%22en-US%22%3EProblems%20populating%20my%20reports%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-793569%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20workbook%20with%20three%20Report%20worksheets%20and%20a%20Data%20Collection%20worksheet.%20The%20Report%20worksheet%20with%20the%20problem%20is%20in%20Page%20layout%208.5x11%20with%20headers%20and%20footers%20with%20the%201st%20row%20repeating.%20The%20footer%20is%20for%20page%20%23%2C%20and%20is%20setup%20for%20Right%20then%20Down%20The%20first%20Row%20is%201%20thru%2010%20pages%20The%20second%20row%20is%20pages%2011%20thru%2020%20ect..%20In%20the%20past%20I%20have%20been%20able%20to%20Copy%20the%20needed%20data%20from%20the%20data%20collection%20sheet%20and%20paste%20it%20into%20the%20report%20in%20to%20A2%20on%20the%20first%20page.%20The%20problem%20is%20the%20data%20goes%20down%20not%20to%20the%20right.%20Any%20help%20I%20can%20get%20will%20help%20Thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-793569%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Frequent Visitor

I have workbook with three Report worksheets and a Data Collection worksheet. The Report worksheet with the problem is in Page layout 8.5x11 with headers and footers with the 1st row repeating. The footer is for page #, and is setup for Right then Down The first Row is 1 thru 10 pages The second row is pages 11 thru 20 ect.. In the past I have been able to Copy the needed data from the data collection sheet and paste it into the report in to A2 on the first page. The problem is the data goes down not to the right. Any help I can get will help Thanks