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?
Bookmarks