Dear MrExcel army, I have recreated an indirect function which I found on youtube, to let a dropdown box select from which tab data is pulled. this is my formula:=INDIRECT("'"&$E$1&"'!E17"). E1 is the reference to the dropdown where I can select tabs box and E17 the value it looks up in other tabs. I want to drag this function down and sideways, so that E17 becomes E18, E19 or F17 etc. When i drag down now, E17 just remains E17 for all the cells. Any help would be greatly appreciated!