Copy Data from various worksheets and display row by row in a single worksheet

[fwd105]

Hi,

I data on a master document and have data sent in from various independent offices which I would like to reconcile. Each region along with the master is posted onto a separate worksheet in my spreadsheet but I would like to copy specific information in worksheet order and paste row by row onto single worksheet in order to run a comparison. The data needed is in the same order but the number of rows reported on each work sheet will differ day by day. If worksheet 1 displays 50 rows in the consolidated sheet I would like worksheet 2 start in row 51, if however worksheet 1 finished in 24, I would like worksheet 2 to start in 25. Now I also want each worksheet to start reporting once the previous worksheet is complete and when there is no data in a specific worksheet, I would like the process to be able to continue.. so sheet 1 reports, then sheet 2 but sheet 3 has no data so it jumps to sheet 4 to begin.

For example consider various cities, New York, London, Frankfurt & Tokyo, each has sales of various products from a catalogue range but the products sold differ each week based on regional trends.
The master document which is independent also reports sales but this is manual so I would like to pick up any inaccuracies through reconciliation.

Outside of VBA and Macros, is it possible to get excel to report data sheet by sheet onto one in a continuous order?

Thanks

 

[oldbrewer]

if the headings and columns are the same in all cases just put ALL the data onto one spreadsheet as it comes in and then analyse it however you want - far simpler !

 

[fwd105]

That would be ideal but the data from each region differs in terms of formatting so I have created formulas to the side of each to extract the data I need.

 

[oldbrewer]

before I retired I worked in business improvement and often came across such scenarios.

MAKE each region use same formatting

ie alter the order of the columns and make column headers the same for all regions

you will save a lot of money that way

you can still analyse by region etc etc