Vlookup in different worksheets

[ErwinR]

Hello. How can I get in a worksheet all the values of let's say cell A5 or column B from several different worksheets?

[Roger Govier]

Hi

Do you mean
=SUM(Sheet1:Sheet10!A5)
This will sum the values of cell A5 across all 10 sheets.

Regards

Roger Govier


ErwinR wrote:
> Hello. How can I get in a worksheet all the values of let's say cell A5
> or column B from several different worksheets?
>
>