How to capture data from next sheet

Hi friends
i have a problem of capture data from next sheet 2 up to sheet 400
in the same column for all sheet
for me i need to capture data in column B359 for all sheet automatic from sheet 2 to sheet 400 to be viewed in sheet 1 in column B1 to B400
thanks all of you.

Assuming sheets are named "Sheet1", "Sheet2" ..."Sheet400"

in B1

=INDIRECT("'Sheet" & ROWS($1:1) &"'!B359")

copy down

Thanks for your response but it does not work

It works if the Sheets are named "Sheet1" etc ... and if you want the data in cell B359 from ALL the sheets.

...Attach a sample workbook (not image).

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

dear friends
i use red and green colours in my attachment to show really what i want

See attached column A

Wondersfull!!!!!!
Thanks a lot i works correct
have a nice time john topley

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