Consolidating data from several tabs into one, side by side

[ChrisGP]

Let's say you have a workbook with 50+ tabs, and you want to consolidate certain data from those tabs into a single tab at the front of the workbook (sheet1). But let's say you want to make the pulled data pull to the right, such that data from sheet 2 might populate column A, sheet 3 data might populate column B, and so on. But the data being pulled from each tab is in the same reference cell(s). Is there an easy way to do this?

[ChrisGP]

no one? Buhler?

[maniacb]

It would be easier to help if you can provide a sample file. You can carry out what your asking by using formulas, maybe you can use power query, or a VBA solution. It depends on your file.