Hello :

I have below formula :

=VLOOKUP(I8,MemPaid!$A2:$H$600,9)
where MemPaid is name of the sheet where the data is.

Now I will have the name of the data sheet picked up from Cell P1.
So basically, if P1 is DonationPaid then the above formula needs to be :

=VLOOKUP(I8,DonationPaid!$A2:$H$600,9)
I hope this is clear.

Please let me know if you have any questions.
Thanks.

RM