Importing data from external source into excel workbook

It may be easier to state what I want my excel workbook to do and hope that someone out there has the answer.

I have a front end screen in excel and would like to enter in a specific number and press “GO” which will then pull data from another workbook and update certain cells in various sheets, I know this requires VBA but have no idea about coding and just need a little help.

cheers