If the name of sheet2 is in cell B1 on sheet1 put the following formulas on
sheet1 in cells:

Q1: =INDEX(INDIRECT($B$1&"!O:O"),MATCH(A1,INDIRECT($B$ 1&"!A:A"),0))
R1: =INDEX(INDIRECT($B$1&"!P:P"),MATCH(A1,INDIRECT($B$ 1&"!A:A"),0))
S1:=INDEX(INDIRECT($B$1&"!Q:Q"),MATCH(A1,INDIRECT( $B$1&"!A:A"),0))

Drag the formulas down columns Q, R and S

Make sure the sheet name in B1 does not have spaces in it.

Tyro

wrote in message
ps.com...
Yes.

Sheet2 in this case is created after the filter is applied (through
VB). Sheet2 is renamed for a specific month upon creation. The name of
Sheet2 is held in a cell on Sheet1.

On Oct 4, 12:30 pm, "Tyro" wrote:
Does the name of the sheet change?
- Show quoted text -