Grab a value from a cell in another worksheet based on that worksheet name

[Misha322]

I have a table in worksheet 'Units' which has a list of values in a column. I also have a number of worksheets who's names correspond with the values in the table in worksheet 'Units' i mentioned previously. In-fact these worksheets tabs are created and named with me running a macro that reference that table in worksheet 'Units'.

What I need is to grab a value from a cell in each of those newly created worksheets and populate second column in my worksheet 'Units' next to its corresponding name/value.

ex:

In my worksheet 'Units' I have a table in column A, starting on A5. The values are: A1, B1, B1A, B1B, etc. I also have worksheets with the names: A1, B1, B1A, B1B, etc. I need to grab a value from a cell in each of those tabs, same cell in each, and place that value in worksheet 'Units'. The command needs to reference table in worksheet 'Units' and find the matching name worksheet and grab the value from the cell in that worksheet, then place it in worksheet 'Units' next to the appropriate cell.

Hope this make seance.

[DGagnon]

you can use the indirect formula for example if A5 is yoru sheet name and the cell you want on that sheet is A1 use:

=INDIRECT("'"&A5&"'!A1")

[Misha322]

Worked great. Thank you!