|Hello Mike |
Sorry my english is not so good :(
I will try again
If i have data inside Sheet1 Sheet2 Sheet3 and on Sheet4 i am colecting data from first 3 Sheets. I don't like to have all 3 sheet data in same time inside of Sheet4. But more to can tell to Sheet4 to go to sheet1 or 2 or 3 and to colect data.
If i put inside A1 fild (from Sheet4) Sheet1 (this need to be text - someting like option to be added by me) and inside A2 fild i add something like =A1!D1 (if i need to relink all filds i will make it like this =Sheet1!D1 - but i don't like to do all this manuali but more that sheet4 is created by him self)
This is more that from A1 fild Sheet4 can reconized that he need to go to one of the sheets and colect data.
A B C D
I hoppe that this is better :(