I want to add up a set of numbers for certain items from 3 different excel sheets but I am unsure how to do so and I could not find anything of help on the web.
Welcome to the forum.
Your case looks close to current ongoing discussion from there:
otherwise just provide more details to us. Thanks