VBA for data importing between workbooks.

Hi,

I have been tasked with creating a pallet tracking system for work, and i have encountered a problem which i'm unable to resolve with google.

Each night at work we complete a Report which details pallet movements throughout the night; this sheet is attached and called "UK Print Sites Master (with After Cut-Offs) TEST FOR PALLETS)". In this workbook there is a tab called "Pallet Control" which collates the pallet movements from previous tabs into a simple table. These figures are represented by '0's in the table.

During the day, a pallet tracking sheet is completed using the details from the report completed during the night; this sheet is attached and called "Pallet Tracking Sheet". The day staff normally print off the night report and manually enter the pallet movements, which i intend to streamline and create an data import function.

So what i am having trouble with is the following:
I would like to create an import function within the "Pallet Tracking Sheet" which will import the data from the "UK Print Sites Master". I would like the '0' figures from the "UK Print Sites Master" to be imported in the corresponding cells in the "Pallet Tracking Sheet".

Other information you may require is that the name of the "UK Print Sites Master" file changes everyday. So i'm not sure whether it would be a .csv import of not.

I am happy to answer any questions and thank you in advance for you help.