Index Multiple Sheets

[INKLO708]

hi there, i am stucked in a situation where i have 4 sheets and 1 as final sheet. i am using formula like =IFERROR(INDEX(PAINT!$D$7:$I$407,PAINT!$C14,COLUMNS($B$7:E14))," ")
for one sheet indexing but my question is what formula should be there for taking all 4 sheets data in final ??
in other words, how to get data of all sheets in final sheet with the help of index.???????

 

[Peter_SSs]

Welcome to the MrExcel board!

Please don't hijack other current threads with your (different question) - start your own. In this case I have moved this for you. Please also take a moment to read our Forum Rules and Guidelines and ensure that you keep within them.

 

[INKLO708]

SORRY I AM NEW THATS Y I DID NOT NO THAT.

 

[sandy666]

what formula should be there for taking all 4 sheets data in final ??

maybe try Power Query aka Get&Transform

 

[INKLO708]

maybe try Power Query aka Get&Transform

its just import data while i need data if changes in all 4 sheets then it must be change in final sheet. hope you got it

 

[sandy666]

all changes in source tables will be reflected in result table after refresh query (final) table. Is that what you want?
hope all source tables have the same structure

 

[INKLO708]

I attached screenshot.

yes above u told me its what i want, can u tell me its proper video or instruction???
any demo???

 

[INKLO708]

=IFERROR(INDEX(PAINT!$F$7:$T$406,PAINT!$D10,COLUMNS($C$7:E10))," ")
I am able to do with just one sheet but for 4 its hard at this time.

so above formula i am using for one sheet..

 

[sandy666]

pictures are the worst idea
post a link to the shared excel file with source tables and expected result, use dropbox, onedrive , googledrive or any similar service
btw. Power Query works with data not formatting and worksheet functions

 

[INKLO708]

okay can you tell me about formula how to select 4 sheets data in index ?????