Hi,

I have master table which has around 30 coloumns and 200 rows, also have 12 other worksheets that I keep data and each worksheet has the similar table of the different year for budgeting purposes.

My master tables first 23 coloumns stays all the time and want to show last 7 coloumns from each worksheet based on a dropdown list that might store the worksheets name. so simply pulling the range from each worksheet for the last coloumns based on a year.

There is indirect function available for pulling a data from another worksheet, but only for a single cell, I was wondering if there is any way to pull a range and plug it in my master table for the last 7 coloumns.

Any help will be greatly appreciated.


Thanks