Hello!

I am fairly new at this, so please forgive me.

I am trying to make a worksheet that will insert data from other worksheet that are saved on my computer. These files are all saved as "Ticket #3405", where the number changes with each ticket. The next file is saved as "Ticket #3405" and so on. I want to create a main worksheet that takes all the pertinent info from these worksheets and automatically inserts them. Essentially, I need to write the ticket# in a column on this main worksheet and have all the info populate other fields in this worksheet. How do I make the worksheet access info from saved spreadsheets on my computer? And how do I make the formula change to access the correct spreadsheet when I type in the ticket #?

Thank you,

Brandon