Copy same cell from multiple sheets into a range of cells in another sheet

[anriley]

I am trying to copy data from cell IF10 in up to 31 sheets and input these data, in order, into a row on another sheet.

More details: cell IF10 in sheet "1" contains a single number (e.g., "3,400"). this number needs to be inputted into sheet "Daily Delivered" in cell C132.

Basically, I need to know if there is a way to take the same cell from multiple sheets and paste the data, horizontally, into a range of cells (C-AG) on a different sheet.

 

[My Aswer Is This]

You said:
More details: cell IF10 in sheet "1"
What exactly is the sheet name.
Is it "1"

Or what.
Why not use a name Like "Alpha" Or "Bravo"
See put the exact name in Quotes like I did

And you said "Copy same cell from multiple sheets"

What does that mean all sheets except for sheet name "1" or whatever.
And if not give names of all the sheets you want included.
And you said:
inputted into sheet "Daily Delivered" in cell C132.

So first into Range C132 then D132 then E132 and so on
If this, correct?
To help you I need specific details like this.

 

[anriley]

You said:
More details: cell IF10 in sheet "1"
What exactly is the sheet name.
Is it "1"

Or what.
Why not use a name Like "Alpha" Or "Bravo"
See put the exact name in Quotes like I did

And you said "Copy same cell from multiple sheets"

What does that mean all sheets except for sheet name "1" or whatever.
And if not give names of all the sheets you want included.
And you said:
inputted into sheet "Daily Delivered" in cell C132.

So first into Range C132 then D132 then E132 and so on
If this, correct?
To help you I need specific details like this.

I ended up just downloading the excel add-on "Kutools" and it solved my issue. Thank you anyways for your help.