Need Help! Transferring Data from one spreadsheet to another at speed???

Can you answer the other questions - the ebay sheet is your spreadsheet - and it looks like a pivot table - so how is this sourced ???

nevis has negative numbers - do you want those in your "stock list" ebay sheet

as i said use a lookup and just copy the data in
heres a sample sheet

On the spreadheet - goto to the stock list sheet
delete the data in stock list
Select A2,B2,C2
then use

Control + Shift + Enter keys
that takes you to the bottom of the data and then right click and clear
now goto the new nevis stock sheet
and select A2,B2,C2
Control + Shift + Enter keys
now right click copy

go back to the ebay spreadsheet - stocklist sheet and
click on A2
right click paste
now all the values are entered into the spreadsheet and updated on the ebay sheet

try that - i can probably improve on it - if its close to what you want

Cell M1 is used as an indirect to stop ref errors on the ebay sheet - so must not be deleted - we can change this as well

the ebay upload is not sourced from anywhere. I created the template/table and the information on it is relative to current ebay listings that I have on ebay now. I can then upload this file via their 'file exchange' system and their system can recognise it and alter my listings.
The ebay upload template can't be altered in any way because eBay will no longer be able to read it.

And no, I can't have any minus numbers. I also noticed there is another issue as well... The stock update that they send me has some errors eg, a duplication of an item and one will say it has 10 stock, and the duplication will say it has -8. The number that isn't the minus number is the correct one.

Using control + F and searching for each item individually to change the stock has proven to be too time consuming