Is there any way to use a dynamic reference inside formula in excel

I'm using an xlookup to reference some data and the formula looks like this : =XLOOKUP($F7,QB_Details!$DI$2:$DI$79,QB_Details!$D$2:$D$79,"No Record",0)
This works fine but I was curious if there is a way to make it more dynamic so these parts: =XLOOKUP($F7,QB_Details!$DI$2:$DI$79,QB_Details!$D$2:$D$79,"No Record",0)
could be altered to account for many different lookup tables, instead of QB it could be 20 other designations that come before "_Details". The dimensions of all the arrays are identical so no need to alter that part of the lookup.

I wanted to have it where a user can select that first part that says QB with one of 20 different choices and then have it point to the proper worksheet. Sorry I don't know if I'm being very clear but let's say they select XY from the dropdown, then the lookup would be =XLOOKUP($F7,XY_Details!$DI$2:$DI$79,XY_Details!$D$2:$D$79,"No Record",0) instead.

I've been looking around for this and haven't seen something that works so far.

Thanks in advance if anyone knows the answer.

Rayburn

Hi, Thank you for your solution Ali, I had to change it slightly as I was getting #REF error, used =XLOOKUP($F6,INDIRECT(""&A9&"_Details!$DI$2:$DI$79"),INDIRECT(""&A9&"_Details!$D$2:$D$79"),"No Record",0), it didn't like the ' within the double quotes. Works perfectly now though, thanks again for your help.

Rayburn

I think I keep posting this wrong, sorry not my strong suit. But thank you, and I just had to leave out the ' from within the double quotes like this : =XLOOKUP($F6,INDIRECT(""&A9&"_Details!$DI$2:$DI$79"),INDIRECT(""&A9&"_Details!$D$2:$D$79"),"No Record",0) and all is working correctly now, thank you again.

Rayburn