How to copy specific cell data from different excel tab into one master tab

[sudheernair]

Hello all,
i have a excel work book containing 20 sheets named by date series like 01.07.2018, 02.07.2018..........20.07.2018.
I want to extract specific cell data from all these sheet into one master sheet.
All sheets formatting is same.

Like i want to extract data from cell "a1" of sheet 01.07.2018 to master data sheet cell "a1"
& -----------------" "------------------"a1" ----------02.07.2018 to master data sheet cell "a2"


can anyone have solution for these.
Because i have many sheets like these and many cell data needs to extract to one master data.


Thanks..............

[Special-K]

Try this (untested)

in the master sheet

in A1

=INDIRECT(TEXT(ROW(),"00")&".07.2018!A1")
and copy down the column

[sudheernair]

Not working................

How can i upload the file here so that it will be easy for the member to provide solution.

[Pat and only Pat]

use button "Go Advanced"

then
Manage Attachments

what's not working ?

=TEXT(ROW(),"00")&".07.2018!A1"
would generate
01.07.2018!A1

so,
=INDIRECT(TEXT(ROW(),"00")&".07.2018!A1")
will copy the value from cell
01.07.2018!A1

[sudheernair]

file is attached for the reference,,,,,,,,,,,,,,,,,i have applied the formula but its not working

[AliGW]

This will work:

Please Login or Register  to view this content.

However, for sheet 02.07.2018, there is a different number of spaces after the sheet name. Why do the sheet names have spaces? You would be better off getting rid of them, and then this would work for all:

Please Login or Register  to view this content.

[sudheernair]

Thanks for the help.............................kudossssssssss

[AliGW]

Thanks for the rep!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.