Calculated Column to the report sheets?

Hi

I have a report sheet but that pulls in data from other sheets, I wanted to add another column that does the vlookup and gets the corresponding values from another sheet.

But in the report version, the only way I could add a column is by referencing it to other sheets. Is there any way I could add a column?

I can create another sheet but it won't stay dynamic incase I add more sheets or rows to the connect sheets.

Thank you