DATA ANALYSIS HISTOGRAM FUNCTION 'MACRO'

I am doing a repetitive task use of the Data Analysis Histogram function on #4 sheets within a workbook - I am seeking is it possible for an automating of the process - which produces a Histogram Result from a bin Range of a Colum of Data.

In each case, I need to press the Data Analysis, select histogram, enter the Input Range, Bin Range and Output Range (selecting a cell) each data piece of which are the same for all #4 sheets. On each sheet I open the above enter the data and press 'OK'. 

I step through each sheet and this takes about 2-3 mins, but would be great if its possible to write a Macro or press one button.

Any ideas would be amazing.

Thank you.............