Assistance Needed to Create Auto-populated List

[DanielleExcel]

Hi
Would like to create a sheet that automatically pulls info from two separate tables when they are pasted into a file. To clarify, two different tables are pulled from a system, pasted onto two separate sheets in an Excel file. I then have to add the two lists together onto another sheet (there is a bit more to it than that but it's essentially the task in the end). Am hoping to find a way to automate the process to save time & reduce errors.
Thinking a sheet full of IF statements but maybe there is a better way?

Thanks
Danielle

 

[jim may]

You are likely going to need to do this using VBA (Macro(s)) and then to do that you're going to have to communicate the details to someone who can write the code lines.
Good Luck...

Jim