pull data from one sheet to another

[mehboobahmad]

Hi mates,

i want to pull data form a google sheet to another sheet within a workbook but you consider the following details.workbook contain on 5 sheets 1- a , 2- b , 3- c , 4-d, 5- is Summary sheetsummary sheet contain on abnormal item numbers of each stationsheet 1 to 4 contains on items in vertical side and stations in horizantally we have 26 stations and each station consist on 5 colums ( Total Issued Quantity, Normal QTY, Abnormal QTY,Remarks & Inspector name)items start from row "27" and stations start from colum "F"summary sheet contains items names vertically and stations name horizantally and station consist on one colums. in summary sheet items start from row"7" and stations start from colum "D". now what we required
1- required to pull data of "Abnormal QTY" colum data of each stations from first sheet into summary sheet